Append 2 Selects? [resolved]

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

Code:

---

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?

Code:

---

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

---

HTH

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?

Code:

---

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

---

When using UNION, distinct values are automatically selected.

cool, thanks guys

UNION
UNION ALL