Hi!
I have a SELECT using a cross join, like this:
SELECT DISTINCT A.* FROM A cross join B where this and that...
But I want results even in the case when table B has no rows.
So I do this:
SELECT DISTINCT A.* FROM A left join B on 1=1 where this and that...
This works, but the 1=1 part is bothering me. If I leave out the "on 1=1" part, I get an error "missing keyword".
Is there another syntax to express this?
Regards,
David