Re^2: 2 mysql selects in one statement

by sulfericacid (Deacon)

on Dec 12, 2006 at 16:33 UTC ( [id://589319]=note: print w/replies, xml )

Need Help??

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

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

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://589319]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others imbibing at the Monastery: (5)

As of 2024-04-25 09:07 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found