Append 2 Selects? [resolved]

[blindlizard]

I need to do something like this in MS SQL Server:

select startdate from classes 
append 
select startdate from events

which should return the startdates from both tables in one recordset, but does not. I only get the startdates from the classes table, not from the events table.

I think I use to do this in my old Oracle days, does SQL Server have something like it?

[Mongo]

SELECT startdate FROM classes 
UNION   -- use UNION ALL if you want duplicate values listed
SELECT startdate FROM events

HTH

[blindlizard]

Thanks, that is it. I need to find a list of keywords and their uses.

So, if I use this then I won't have any duplicates in the recordset?

SELECT distinct startdate FROM classes 
UNION  ALL
SELECT distinct startdate FROM events

[mendhak]

When using UNION, distinct values are automatically selected.

[blindlizard]

cool, thanks guys

[sw_is_great]

UNION
UNION ALL