Union

[accessman2]

In SQL Server,

query:

Can I use union function?

 

[SQL_Hell]

yes you can

 

[ozinm]

There's a nice quick SQL reference on MS's site.
It's quite useful when you're getting started and not quite sure about syntax.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_operator_1qd5.asp

All the best
Marc