×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
