Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^2: 2 mysql selects in one statement

by sulfericacid (Deacon)
on Dec 12, 2006 at 16:33 UTC ( #589319=note: print w/ replies, xml ) Need Help??


in reply to Re: 2 mysql selects in one statement
in thread 2 mysql selects in one statement

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"


"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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://589319]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2015-07-30 02:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls