Re: SQL ?

Select Sal_ID , Sal_Site , Pay_Date, Name  From Salary S, Employee E
Where S.Sal_id = E.ID
UNION
Select Sal_h_ID , Sal_h_Site , Pay_Date, Name From Salary_Hist S1, Employee E
Where S1.Sal_h_ID = E.ID Received on Mon Dec 10 2001 - 16:49:57 CST