Selecting ids where am/pm cols not null for whole week
Try this
select unique t1.id
from your_table t1
where 0 = (select count(*)
from your_table
where t1.id = id
and am_col IS NOT NULL
and pm_col IS NOT NULL
and st_date between <date1> and <date2>)
I have not tried it, so I am noty guaranteeing it will work. Also its not
very efficient.
Mark Denham
BBC
London, UK
Mark.Denham@bbc.co.uk