Re: SQL HELP

["Bob Bledsoe" <bledsoe.bob@xxxxxxxxx>]

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.