Shorter use of UNION?

[Sleidia]

Hello,

Is it possible to avoid listing all the columns when you use UNION?

I'm looking for a way to use ' * ' ... something that would look like this :

SELECT 
*
FROM 
my_table

UNION

SELECT 
'' as *
FROM 
my_table

Thanks!

 

[r937]

could you explain why you are trying to do that?

obviously what you wrote won't work

you seem to want to return all columns of all rows and then something else? what's the something else for?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon