trick: get a non-empty recordset with NULLs

2015-02-26 10:31  i3098    [permalink]

If you ever need a non-empty recordset with all NULL values, e.g. for listing the columns:

select C.* from (select 1 X) X left outer join Customer C on C.ID=0

→