I have a table containing jobs and dates that work was done on these jobs:
Job Date Work Done
A 01 Jan 2013
A 02 Jan 2013
A 03 Jan 2013
B 02 Jan 2013
B 03 Jan 2013
C 03 Jan 2013
I want to know which jobs started on say 02 Jan 2013 - the answer is job 'B'.
What would be the query for this?
Thanks.