Hi all. How do you check if a record doesn't exist? I want to return an empty string for column3 if there isn't a record for mytable3. There's data for column1 and column2. Instead it's not returning any records at all. Thank you. :crazy:
select column1, column2,
case column3
when null then ''
end
from mytable1 a
inner join mytable3 b on a.columnX = b.columnX