Testing for the absence of child records in MySQL -


I have two database tables with one-to-one relationship. Is it possible to select a record from the 'one' table? Is there any record present in the 'many' table with no single SQL statement available? if so, how?

Thank you in anticipation.

Use one:



Comments