How to insert a blank "dummy" column into a Table? 1

[dannydanny]

Hi,

I have run an SQL query in Access97. I want to add another blank column into the query results so that I can do a UNION query using this table and another table which has an extra column.

Is this possible with a SQL query statement?

Thanks for any info.
Danny

 

[KenReay]

Hi

You mean a 'ghost' column, just to balance up with the Union?

Yes - do it so

SELECT MyCol1, MyCol2, " " As MyDummyCol FROM MyTable

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dannydanny]

Hi,

Thanks for the reply Ken, it was exactly was I was after!

Cheers,
Danny