Re: 2 mysql selects in one statement

don't toss some advanced techniques my way.

I fear you're not going to get very far wo/ some "advanced techniques", assuming you consider JOINs to be advanced.

A JOIN is what you're attempting, except you haven't specified any key columns in your queries. Presumably, "name" is the primary key of db1...hopefully, "name" exists as a foreign key in db2. In which case your 2 queries get folded into a single joined query:

SELECT db1.name, db1.age, db1.email, db2.height, db2.weight, db2.shoes
+ize
FROM db1 JOIN db2 on (db1.name = db2.name)
[download]

(or somesuch JOIN syntax; I leave the details to you and your MySQL docs to figure that bit out.)

fixed typo in my JOIN: "JOIN db1" should be "JOIN db2"

Perl Contrarian & SQL fanboy

Comment on Re: 2 mysql selects in one statement Download Code

Replies are listed 'Best First'.
Re^2: 2 mysql selects in one statement by sulfericacid (Deacon) on Dec 12, 2006 at 16:33 UTC
I'm not exactly sure JOIN is the way to go. I'd use `SELECT db1.name, db1.age, db1.email, db2.height, db2.weight, db2.shoes +ize FROM db1, dbi WHERE db1.name = db2.name AND other="test"` [download] "Age is nothing more than an inaccurate number bestowed upon us at birth as just another means for others to judge and classify us" sulfericacid	[reply] [d/l]