|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.