Select command doesn't return anything
I need to show the hours avaible on each doctor but my code returns
nothing Here's my code:
SELECT DISTINCT Hours
FROM agenda_hours, doctor
WHERE Agenda_Hours.idHours NOT IN (SELECT DISTINCT appoitment_hour.Hour
FROM appoitment_hour)
AND Doctor.Name IN (SELECT Doctor.Name FROM Doctor Where name = "Name");
No comments:
Post a Comment