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

Vernon,

That works!

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:17 AM
                      Please respond to
                      midrange-l






Oops - didn't get your spec.

Change to

select F1A, F1B, F1C, F2F, F3B
from FILEA join FILEB on F1A = F2A || F2B || F2C
      join FILEC on F2E = F3A
where F1C = 'XYZ' and F3C = 'Y'

The query runs, but I didn't put in any data

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

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