
November 23rd, 2012, 12:18 PM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 1
Time spent in forums: 4 m 45 sec
Reputation Power: 0
|
|
|
Strugling to write what should be a simple select!!
Hi All,
Read my out of date book, tried to dredge my ancient memory for what I learned at uni 20 years ago, seached the net....
I need a query...
Given the table JOBS.
ID JOB LinkedUsers
20 70 1
21 71 1
22 71 2
23 72 1
24 72 2
25 73 1
26 74 1
27 75 1
28 75 2
I need to return "jobs" that that only have a user of "1" and not a user of "1" and "2"
so the output would be
70
73
74
Thanks
Rob
|