SQL question
From: Keith S. <kshave_at_mbnet.mb.ca>
Date: 1998/09/22
Message-ID: <szQN1.196$E_2.195669_at_typhoon.mbnet.mb.ca>#1/1
Date: 1998/09/22
Message-ID: <szQN1.196$E_2.195669_at_typhoon.mbnet.mb.ca>#1/1
I have 3 tables I want to query.
TABLE A
col m
col n
TABLE B
col m
col x
TABLE C
col x
col y
I wish to select a.m,b.x,c.y
from a,b,c
where a.m = b.m
[Quoted] and b.x = c.x
Now, I wanted to outer join tables A and B because I still want to include the a.m values for table A records with no corresponding table B records. However, these table A records were not showing up because of the link of table B to table C. Any suggestions?
-- Keith Shave Management Information Services Ph: (204) 945-7937 Fax: (204) 948-2542Received on Tue Sep 22 1998 - 00:00:00 CEST