Posted by Richard on 11/18/07 03:24

Hello,

I have 2 tables: Employees(EmployeeID, FirstName, LastName),
EmployeeApplication(CreatedByID, EmployeeID,Date1, Date2, Content...)
I need to create stored procedure that will return employee First and
Last names (plus some other columns) instead *both* ID's in
EmployeeApplication.
I know how to do it with only one - I am using simple join, but with
two I have no idea...
Can anyone help me ?

Richard...

• Next in forum: Re: Beginner question, stored procedure
• Prev in forum: MI5 Persecution: Eclipse pub 20/12/02 (26623)
• Thread view: Beginner question, stored procedure

[Reply to this message]