Union query problem

[shteev]

Hi, I want to make a union query which adds 2 tables together; but I want it to contain a field which is in one table, but not the other. For entries in the second table, I want the union query to contain a NULL. So, something like this:

SELECT [field1], [field2], [field3]
FROM [table1]
UNION
SELECT [field1], [field2], [just have a load of NULL fields]
FROM [table2]

Is this possible?

 

[RoyVidar]

Hi!

Have you tried something like this:

[tt]SELECT [field1], [field2], [field3]
FROM [table1]
UNION
SELECT [field1], [field2], null as myfield
FROM [table2][/tt]

or

[tt]SELECT [field1], [field2], [field3]
FROM [table1]
UNION
SELECT [field1], [field2], "" as myfield
FROM [table2][/tt]

Roy-Vidar

 

[shteev]

This works great! I had tried [null] which didn't work for reasons which appear all to obvious to me now...