×
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.
John -
Or, if you are looking for the Master records, do the query in reverse:
Select * from Master where Master.ID in
(Select Detail.ID from Detail where Detail.ID = somevalue)
- sjl
"sjl" <sjl_abc@xxxxxxxxxxx> wrote in message
news:mailman.9453.1243606992.23468.midrange-l@xxxxxxxxxxxxxxx
John -
Does this help?
This query will show you all detail record were ID = somevalue
ordered by FUNCTION
- sjl
John wrote:
I have two files, Master and Detail. They share a common key, ID.
There can be any number of Detail records, even zero, for every Master
record.
The Detail records have a secondary key sequence, FUNCTION, in ascending
order.
There are several instances where the Detail records for one
Master record are the same as the Detail records for another Master
record.
In the past, I have tried to locate these by using RPG and building big
variables containing the FUNCTION, then sorting them. Still was a manual
process to examine how closely the records matched.
Can SQL do this?
midrange.com
