constructing SQL problem

[Krasimir_Slaveykov]

Hello ,

I have a problem with constructing correct SQL.
I have tables:
TABLE1 wich have FIELD1 and FIELD2
TABLE2 wich have FIELD1 and FIELD2
TABLE3 wich have FIELD1, FIELD2 and FIELD3

I have this SQL:
select a.field1, a.field2, b.field2, c.field2
from TABLE1 as a, TABLE2 as b, TABLE3 as c
where a.field1=b.field1 and
a.field1=c.field1 and
c.field3<>'string'

My problem is that when C.FIELD3 is null i.e. in TABLE3 no record,
these records are excluded from results. I needed them nevermind they
have record in TABLE3 or not.
Anyone help?


--
Best regards,
Krasimir_Slaveykov mailto:kr***@hq.office1.bg
sy******@hq.office1.bg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw