Sybase Select Statement

I am trying to select with some specific conditions but cannot seem to get what I am wanting. Table Person person_id | first_name | last_name Table Service service_id | person_id

Solution 1:

Your last condition should be

AND ((P.last_name LIKE 'Mar%' OR ST.description LIKE 'Fusions%') 
OR (ST.description LIKE 'New%' AND SU.user_id = 'Bob' AND start_time >=  2009-01-01'))