Retrun 1 row from join statement

[blar9]

Here is a query below I want to get all this information back plus some but the problem is the pictures. There can be more than 1 picture in the database. I just want to return the latest picture using pic.DateOfPicture so I dont get more than one row. I cannot use distinct because of the image listed.

SELECT Emp.EmployeeUID, pic.Picture, emp.FirstName, emp.LastName, pic.DateOfPicture
FROM emp_General emp Left Outer JOIN
Client_pictures pic ON Emp.EmployeeUID = pic.EmployeeUID

 

[Qik3Coder]

this is pseudo, you may have to tweak it

SELECT     Emp.EmployeeUID, pic.Picture, emp.FirstName, emp.LastName, Max(pic.DateOfPicture)
FROM       emp_General emp Left Outer JOIN
           Client_pictures pic ON Emp.EmployeeUID = pic.EmployeeUID
GROUP BY Emp.EmployeeUID, pic.Picture, emp.FirstName, emp.LastName
HAVING pic.DateOfPicture = Max(pic.DateOfPicture)

-The answer to your problem may not be the answer to your question.