Hi
I have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
If
(SELECT COUNT(distinct SalesmanID)FROM Appointments)
=
(SELECT COUNT(SalesmanID) FROM Salesmen)
View Complete Post