Hi I'm trying to union two queries but one has 2 columns and the other has 1. I want to populate the short query with a column matching name and filled with nulls

Query with 4 columns

select a, b,  from alphabet

query with 3 columns

select a, null as b from alphabet

null as b is not the correct syntax to do this.

On 4/9/2015 9:52 AM, Boss wrote:
> Hi I'm trying to union two queries but one has 2 columns and the other has 1. I want to populate the short query with a column matching name and filled with nulls
> select a, null as b from alphabet

DBISAM does not like "null as b" (it would work for things like string
though '' as c).

I would use something like as a workaround :

select a,NULLIF(a,a) as C from mytable

Raul