combine two databases (mySQL)

ugasucks

i have two databases, one with twelve columns and one with four columns. the two databases share a common account code that i use to match the two DB together. i only need one column from the smaller database, and this column will need to be inserted into one field of the output results...

i'm somewhat new to mySQL, so i'm unsure of how to control how an output set will look... when i do :

SELECT * from db1, db2 where db1.acct = db1.acct

i only get the output from db2 joined on the end of db1... but because there are, say 1 reference to acct1 in db1, but 22 references to it in db2, some output is being duplicated.

i need something like the following:

+---------+--------+------------------------------+--------------+
|acct.......|..num..|.......+===========+..|....other......|
|.............|...........|.......||........................||..|...................|
|.............|...........|.......||.......from..........||..|...................|
|.............|...........|.......||.........db2.........||..|...................|
|.............|...........|.......||........................||..|...................|
|.............|...........|.......+===========+..|...................|
|.............|...........|......................................|...................|

ugasucks

sorry about the image... ASCII art isn't what it used to be

ultraslacker

I assume you have 2 tables in one database.

SELECT desired_column
FROM table_1 t1, table_2 t2
WHERE t1.acct = t2.acct

ugasucks

yes, i have the two tables in one DB. the query that you sent is what i need to do-- i just need it to be a resulting field from a larger query... here's what i'm trying to say:

i want to show the user all the contents of table1. in addition, i want one field of the output to be the result of another query -- this is the above query (from slacker.)

so, i think it would be something like this:

SELECT from table1, ( from table2 where table1.acct=table2.acct) as innerChild, from table1

does this make it clearer?