blossompark
asked on
sql server 2005 union query where tables have some different columns
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your input....not homework...just under a lot of pressure here to produce something and hard to think straight...
Hi Angelgeo,
thanks for that, saw something similar on google but was using NULL only as a column name and didnt work...so I'll put in the "AS" and i'm sure it will be fine...
thanks again...