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

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Nothing fancy here, it seems. Just join in the order given.

select F1A, F1B, F1C, F2F, F3B
from FILE1 join FILE2 on F1A = F2A and F1B = F2B and F1C = F2C
      join FILE3 on F2E = F3A
where F1C = 'XYZ' and F3C = 'Y'


At 10:59 AM 4/3/02 -0500, you wrote:
>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.