Mutiple Table Join Question

[kcaenj]

I have a main table that has a list of employee IDs that need to be looked up.

There are two types of employees (Active and Terminated). I have two other tables that have both of these types of employees (called Active and Terminated). The field I am referencing for both of these tables is CompanyCode.

How would I write SQL that will do a join either if the WWID matches the Active Employee Table or the Terminated Employee Table.

Thanks,

KC