Re: SQL HELP

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

Thanks guys. That takes care of it.

On 3/14/07, nike@xxxxxxxxxxxxxx <nike@xxxxxxxxxxxxxx> wrote:
> Hi Bob,
>
> select subac00001, count(*) table1 group by subacc00001 having count(*)=1
>
> JD
>
> Bob Bledsoe
> > 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.