Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: joining two tables in mysql

by UnderMine (Friar)
on May 15, 2006 at 09:59 UTC ( [id://549420]=note: print w/replies, xml ) Need Help??


in reply to joining two tables in mysql

There are two forms of join syntax. The first is the JOIN command explained above. The other is to use the where clause

SELECT * FROM voice_calls , customers WHERE customers.id = voice_calls.customer_id

In order to get unique column names you will need to look up aliasing in the SQL manuals. MySQL SELECT Syntax

Hope this helps

UnderMine

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2024-04-25 19:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found