« first day (390 days earlier)      last day (121 days later) » 

1:36 AM
-6
Q: What is wrong with this syntax?

John StuartSELECT C_id FROM appointment WHERE S_id LIKE '%DR%' AND C_id NOT EXISTS IN( SELECT C_id FROM appointment WHERE S_id LIKE '%HW%' AND S_id LIKE '%SW%') I'm trying to select the Customer ID who used the service DR but not other service HW and SW.

 
 
22 hours later…

« first day (390 days earlier)      last day (121 days later) »