RE: How do I code this in a SQL SELECT?

["Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Mark,

Perhaps I am still in brain dead mode, but I am not understanding your
question, I am confused in part because I am thinking that the F?? is the
key in all three files and there is no place where the keys intersect, and
also where is the data "XYZ" and "Y" going to be found in any of the example
tables?

-----Original Message-----
From: Mark Phippard [mailto:MarkP@softlanding.com]
Sent: Wednesday, April 03, 2002 11:00 AM
To: midrange-l@midrange.com
Subject: How do I code this in a SQL SELECT?


Consider the following three file definitions:

FILE1
F1A    PK    10
F1B          40
F1C          10

FILE2
F2A    PK     4
F2B    PK     4
F2C    PK     2
F2D          40
F2E           1
F2F          10

FILE3
F3A    PK     1
F3B          10
F3C           1

Files 1 and 2 could be joined by either combining the three key fields in
FILE2, or substringing the one field into the three subfields.

Files 2 and 3 can be joined by fields F2E and F3A.

Now, how can I do a SQL SELECT where I get the following fields:

F1A
F1B
F1C
F2F
F3B

Where F1C = "XYZ" and F3C = "Y'

With all of the proper joins being honored, etc...?

Thanks

Mark




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.