469,948 Members | 2,737 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,948 developers. It's quick & easy.

constructing SQL problem

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

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
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1463

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by karthick | last post: by
1 post views Thread by cainlevy | last post: by
19 posts views Thread by Michael Schuerig | last post: by
5 posts views Thread by grocery_stocker | last post: by
1 post views Thread by Gravy | last post: by
6 posts views Thread by Big George | last post: by
1 post views Thread by nabil | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.