Re: SQL Help

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Thanks Birgitta. That worked.  Also, a coworker used this:

SELECT  count(*) from
(SELECT  iucarton#
FROM ptiis00  inner join
ptiiu00 on isdid# = iudid#
 and  isseq# = iuseq#
 and  isline# = iuline#
WHERE isdid# = 16571777
 and ispkgType = '001'
group by iucarton#) as aa

On Tue, May 15, 2018 at 1:04 PM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> Remove le GROUP BY
>
> 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!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Art
> Tostaine, Jr.
> Sent: Dienstag, 15. Mai 2018 18:55
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: SQL Help
>
> I'm trying to count the number of cartons in a joined table.
>
> SELECT  count(distinct IUCARTON#)
> FROM ptiis00 inner join
> ptiiu00 on isdid# = iudid#
>  and  isseq# = iuseq#
>  and  isline# = iuline#
> WHERE isdid# = 16571777
>  and ispkgType = '001'
> group by iucarton#
>
> I get 63 rows returned, I want one value returned, 63.
>
> Any help appreciated.
> --
> Art Tostaine
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> http://amzn.to/2dEadiD
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD