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


 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-2542
Received on Tue Sep 22 1998 - 00:00:00 CEST

Original text of this message