Re: Join *LF with keys from different PFs

You mean like this:
SELECT VIDALA.FLDA, VIDALA.FLDB, VIDALB.COLA, VIDALB.COLB
FROM VIDALA JOIN VIDALB ON VIDALA.FLDA=VIDALB.COLA 
ORDER BY VIDALA.FLDB, VIDALB.COLB 

Too bad you can't create a permanent INDEX or VIEW, (or even LF), like 
this.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Peter Vidal" <Peter_Vidal@xxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/17/2003 03:27 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     midrange-l@xxxxxxxxxxxx
        cc: 
        Fax to: 
        Subject:        Join *LF with keys from different PFs


List:

I have this need and I have not found a good example yet.  Do you have any 
that
you may share?  What I want is to  join two *PF files and also define my 
key
fields from fields from both *PF files.

Thanks in advance,
Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com

"A good player makes himself look good; a great player makes the team look
good."
Author unknown


_______________________________________________
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.