Hey all,
Suppose I have this...

Code:
SELECT a.x, a.y, a.z,
            b.x, b.y, b.z
FROM tableA a
LEFT JOIN tableB b ON a.x=b.x AND b.w="somevalue"
This should return all rows from tableA and for those rows where a.x=b.x AND b.w="somevalue" the rows will be appended with b.x, b.y and b.z

Is there a way to set default values the b.x, b.y and b.z for those rows that did not meet the join condition?

Right now I get null for those values, and it would really make life simpler if they had default values.
thanks
kevin