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

["Mark Phippard" <MarkP@xxxxxxxxxxxxxxx>]

Vernon,

Files1 and 2 do not join in the manner you specified.

The three fields in File2 (F2A, F2B and F2C) would have to be concatenated
to join with F1A (or F1A would have to be substringed.)

That is the part that is throwing me, as I have never coded something like
that before in a SELECT.

Thanks

Mark







                      Vernon Hamberg
                      <vhamberg@attbi.co         To:      
midrange-l@midrange.com
                      m>                         cc:
                      Sent by:                   Subject: Re: How do I code 
this in a SQL SELECT?
                      midrange-l-admin@m
                      idrange.com


                      04/03/02 11:11 AM
                      Please respond to
                      midrange-l






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.

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