Home -> Usenet -> comp.databases.oracle -> SQL question

SQL question

From: Paul Krikorian <paulk_at_uhura.dis.cccd.edu>
Date: 6 Feb 1994 08:12:17 GMT
Message-ID: <2j28p1$5ii_at_spock.dis.cccd.edu> 






I know some simple SQL, but I'm not sure how to go about doing the following.



I have three tables from which I would like to extract certain related 
columns of data into one row.  The link between the first two tables will
always be there, but the link between the second and third table may not.
However, I would still like to return all the columns from the first and
second tables regardless of whether or not the link between table two and
three exists.  How do I go about doing this?  I've tried the follwing, but
it will not return a row if the link between table two and three is missing.



SELECT T1.a, T2.b, T3.c


  FROM tbl_1 T1, tbl_2 T2, tbl_3 T3


 WHERE T1.a = T2.a AND T2.b = T3.b



Any help would be greatly appreciated!



Thanks in advance.


-- 
Paul Krikorian                   | Internet: paulk_at_uhura.dis.cccd.edu
Coast Community College District |           (or paulk_at_cccd.edu)
1370 Adams Ave.                  |    Voice: (714) 432-5150
Costa Mesa, CA 92626, USA        |      Fax: (714) 432-5062


Received on Sun Feb 06 1994 - 09:12:17 CET












Original text of this message