×
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.
I'm trying to join a master record to a detail file in which there may be 0
- 2 matching records and turn it on it's side. I can easily do this if
there are always two matching records but can't figure out how to handle
the other two situations (no matching or just one matching). The end
result should look like this:
Acct#, Day1, Day2
Master record has account# and other needed information for final results.
Detail record has account# and Day which is 1 -31.
Results could like this:
Acct#, Day1, Day2
1 1 15
2 1 0
3 0 0
Day1 should be lesser of both days.
It's straightforward if both detail records are there using group by with
Min and Max. We're still on 5.4 and at least a month away from 7.1.
Thx
Jack
As an Amazon Associate we earn from qualifying purchases.
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
