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.fiel d1 and
a.field1=c.fiel d1 and
c.field3<>'stri ng'
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_Slavey kov mailto:krasi@hq .office1.bg
sysadmin@hq.off ice1.bg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw
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.fiel d1 and
a.field1=c.fiel d1 and
c.field3<>'stri ng'
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_Slavey kov mailto:krasi@hq .office1.bg
sysadmin@hq.off ice1.bg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw