Re: SQL HELP

Birgitta,
  That seems to be the perfect solution. It does the trick and runs much
faster.

Thanks


On 3/15/07, BirgittaHauser <Hauser@xxxxxxxxxxxxxxx> wrote:

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
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.