×
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.
On 11/26/19 11:26 AM, Alan Shore via MIDRANGE-L wrote:
Do an exception join on the detail file
This will list all the detail records that do NOT have an order number in the header file
Select a.* from ORDDETAIL a exception join ORDHEADER b on
a. ODOHNO = b. OHOHNO
Thanks to everybody. I used Mr. Shore's syntax, but only because it was
the first answer I looked at with example syntax.
A follow-up question:
If I do the above with "select count(odohno)," I get 126000. Based on
another information source, that seems high. If I then add "group by
odohno," I see that there are lots of odohno values with more than one
record.
How would I get the total number of distinct odohno values? I tried
"select distinct count(odohno)," and it still gave me the 126000.
--
JHHL
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
