AW: SQL HELP

Hi,

I'd use the following statement:
With x as (Select   subac00001
              From  MyTable
              Group By Subac00001
              Having Count(Subac00001) = 1)
Select a.* 
  From MyTable a join x on a.Subac00001 = x.subac00001

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Bob Bledsoe
Gesendet: Wednesday, March 14, 2007 22:03
An: RPG400-L@xxxxxxxxxxxx
Betreff: SQL HELP


I have a file with field subac00001. I only want to select records that have
no matching number in subac00001. for example from the records below i would
only select 80989388. How do you do this with SQL?

subac00001     field2
80989121        80,989,129
80989121        80,989,130
80989388        80,989,392
80989409        80,989,414
80989409        80,989,415
80989428        80,989,436
80989428        80,989,437

Thanks, Bob B