Select S.ID
FROM dbo.tblssms S LEFT JOIN 
([DBname].[dbo].[tblAdditionalPrograms] P
INNER JOIN [DBname].[dbo].[tblAdditionalProgramsDefs] 
ON P.[RecCodeID] = [DBname].[dbo].[tblAdditionalProgramsDefs].[ID])
 ON S.ID = P.ID

Select S.ID
FROM dbo.tblssms S 
LEFT JOIN 
(
Select ID,* from [DBname].[dbo].[tblAdditionalPrograms] 
INNER JOIN [DBname].[dbo].[tblAdditionalProgramsDefs] ON [DBname].[dbo].[tblAdditionalPrograms].[RecCodeID] = [DBname].[dbo].[tblAdditionalProgramsDefs].[ID]
)P ON S.ID = P.ID

quote:

---

Originally posted by Niki

Yes, Sodeep.
Thank you! it worked.

Niki

---