[RESOLVED] All the rows that have no related record in other table

[mrgrammar]

I have two tables

CLIENT
client_id, client_name

SURVEY
survey_id, survey_client, survey_date

The two tables are related one (CLIENT) to many (SURVEY) client.client_id = survey.survey_client

Could someone show me a query that shows only the clients from the CLIENT table that have no related record in the SURVEY table.

[mrgrammar]

mrgrammar;10973244 wrote:

I have two tables

CLIENT
client_id, client_name

SURVEY
survey_id, survey_client, survey_date

The two tables are related one (CLIENT) to many (SURVEY) client.client_id = survey.survey_client

Could someone show me a query that shows only the clients from the CLIENT table that have no related record in the SURVEY table.

I found the answer at:
http://www.freeopenbook.com/mysqlcookbook/mysqlckbk-chp-12-sect-6.html

SELECT c.client_id, c.client_name FROM client as c
LEFT JOIN survey as s ON c.client_id = s.survey_client
WHERE s.survey_id is null