In SQL Server,

query:

Can I use union function?

yes you can

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