SELECT to return "1" in a null field

[quanghoc]

I have a SQL statement like this:
SELECT table1.*,table2.field1 FROM table1 LEFT JOIN table2 ON (something) WHERE (something_else)
I want field1=1 instead of null if there is no record in table2. How to do this. Please help. Thanks.

[Lars_Berg]

SELECT table1.*,coalesce(table2.field1,1) FROM table1 LEFT JOIN table2 ON (something) WHERE (something_else)

[quanghoc]

Awesome!! Works perfect. Always learn something new on every question in here.