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
|
|---|