Results 1 to 4 of 4
Thread: question on join in sql
Jan 12, 2005, 13:24 #1
question on join in sql
Not sure if this is specifically a join question or maybe it's a sub query. Here's the query I'm currently using:
FROM tbl45 LEFT JOIN tbl3 ON tbl45.col3 = tbl3.col1
WHERE ((tbl45.col1)<>31) AND (tbl45.col2)=(SELECT col2 FROM tbl45 WHERE col1=31)) AND (tbl3.col22)=0) AND (tbl45.col41)=0));
When there are no matching records in tbl3 I'd like it to still show the rest of the data. But with the tbl3.col22=0 it won't. Is there a way around this?