| Subject | SQL for master-detail |
|---|---|
| Author | Ed Dressel |
| Post date | 2007-12-27T17:29:43Z |
I am looking for all of the master records that have one or no detail
records.
Select Master_ID from MasterInfo where Master_ID (select Master_ID
from DetailInfo where [less then one record])
Can this be done without a stored proc?
records.
Select Master_ID from MasterInfo where Master_ID (select Master_ID
from DetailInfo where [less then one record])
Can this be done without a stored proc?