Saturday, 24 August 2013

Select command doesn't return anything

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