if stmt within query?

[ecannizzo]

Can I do something like this within my query?

if h.notes = "Issue" then
left outer join ISSUES i on h.record_id = i.id
else
left outer join ISSUES2 i on h.record_id = i.id
end;

thanks.

 

[Thargy]

No.

Regards

T