I'm using an outerjoin with ISNULL as follows to populate a gridview on a webpage:
SELECT id,thing1,ISNULL(valid, 0) as Valid
FROM things as d left OUTER JOIN thing2 r ON d.ID=r.parentThingID
WHERE d.ID =1
Which returns the correct results (thanks guys!)
when I try to populate the grridview, the checkboxes fail to "check" based on the value in valid:
i.e. Checked='<%# Convert.ToBoolean(Eval("Valid")) %>'/>
The check box gets populated fine if I'm just using a straight queary without using the ISNULL. (where none of the values are null).