Combining Data from 2 tables help

Hi...

I have two tables (teachers, students) each table has 3 fields (FirstName, LastName, EMail). I'm trying to combine the data from both tables into one so I have a "master list" to send e-mails to all teachers and students via an ASP script/CDO.

I've been reading up on Joins but I can't figure out the SQL to combine data from both tables. Any ideas?

Thanks,
Steven Lee

did you check here?
http://sqlcourse2.com/joins.html

post back up if that doesnt help or if you are running into a specific problem

Shouldnt it be

SELECT First, Last, Address
FROM Teacher, Student;

?

Didn't try that...

But

Select * From Teachers
Union
Select * From Students


seems to work

thanks and cheers

Steve