Re: sql select count(*) and join

SELECT count(a.*) FROM header a join detail b on hord=dord WHERE > a.xxx <> 0 and a.yyy=0

Jeff - got an error

Token * was not valid. Valid tokens: DAY RRN CAST CHAR DATE

SELECT count(a.*)FROM hord a join dord b on
wowono=wono WHERE woblmm=0 and woesth<>0
jim

----- Original Message ----- From: "Jeff Day" <Jeff.Day@xxxxxxxx>
To: <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Monday, June 04, 2007 11:09 AM
Subject: Re: sql select count(*) and join

You already have the alias specified, have you tried:
a:
SELECT count(a.*) FROM header a join detail b on hord=dord WHERE
a.xxx <> 0 and a.yyy=0

b:
SELECT count(a.*) FROM header a join detail b on hord=dord WHERE
a.xxx <> 0 and sum(b.a + b.b + b.c) <>0

"Jim Franz" <franz400@xxxxxxxxxxxx> 06/04/07 11:04 AM >>>

Just not getting it....
Need several counts between a header & detail file
1. SELECT count(*) FROM header a join detail b on hord=dord WHERE
a.xxx <> 0 and a.yyy=0
This is counting the detail records.... I need header counts.

2. SELECT count(*) FROM header a join detail b on hord=dord WHERE
a.xxx <> 0 and sum(b.a + b.b + b.c) <>0
This is counting the detail records.... I need header counts.

Appreciate any pointers. The 3 SQL books I have are useless in
examples
for this.
jim

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



This message has been scanned for viruses by MailControl -
www.mailcontrol.com

Click
https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
to report this email as spam


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.