SQL Union and blank spaces or fillers??
583143Apr 30 2008 — edited Apr 30 2008Quick question folks;
I am writting an SQL script with a union and the second half doesn't use the same fields as the first one.
What is the correct code to allow for fillers to be used.
I am trying this:
'',''
and it works on it's own sql statement, but when put in with the UNION it comes back with the query block has incorrect number of result columns.
Thanks in advance