yoy.be "Why-o-Why"

2015 ...

januari (2) februari (1) maart (1) april mei juni (5) juli (1) augustus september (3) oktober (3) november (1) december (4)

trick: get a non-empty recordset with NULLs

2015-02-26 10:31  i3098  coding  [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