var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Selecting duplicates only
I have tables as below
Employees(EmployeeNum, Department, Division ... )
Appr(UniqueID, EmployeeNum, ApprDate, ApprType ... )
Where one employee can have many records in the Appr table.
Basically, what I want is to pick out employees who have multiple records in the Appr table.
Is this at all possible?
Please ask any questions needed!
where EmployeeNum in
( select EmployeeNum
having count(*) > 1 )