SQL question

 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
 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 - 11:50:32 CDT