Archives of the TeradataForum

Message Posted: Tue, 20 May 2003 @ 10:28:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Wouldn't it be better?

Select
Employee.Employee_Number,
Employee.Name,
Employee.Date_Of_Birth,
Employee.Department,
Employee.Date_of_last_review,
W_Review_Date.Pay_Rise_Given
From Employee,
(Select Employee_Number,Pay_Rise_Given
from Review_Date )
                                as W_Review_Date
where
W_Review_Date.Employee_Number=Employee.Employee_Number
and
W_Review_Date.Date_Of_Review=Employee.Date_of_last_review

	<Prev	Next>		<<First	<Prev	Next>	Last>>