Selecting from multiple tables (MySQL)

[Anon]

I've got two tables, "Clients" with id, name, password, date and "Calls" with id and columns a to q.

This is what I would like do do:

SELECT id, name(from clients table with the same id as in this table), a, b, c, d... FROM calls WHERE $select_criteria GROUP BY id ORDER by name DESC

How?

Thanks!

[Anon]

SELECT calls.*, clients.name FROM calls INNER JOIN clients ON clients.id = calls.id WHERE $select_criteria GROUP BY id ORDER BY name DESC

This joins the tables, where the id's are the same, if an id exists in the calls table twice (a one-to-many relationship), it will create two rows, where the client.name would be the same, but with different call info.

If it's a one-to-many relationship, ie, id's in the calls table may be duplicated, it's probably best to add a primary key to that table, to aid in editing those rows., such as use "id" as the key, and a "client_id" for the client id and linking.

HTH