SELECT dbo.PC_PD_REL.*, dbo.[PROCEDURE].*, dbo.PROCESS.PC_Name AS Expr1
FROM dbo.PC_PD_REL INNER JOIN
dbo.PROCESS ON dbo.PC_PD_REL.PC_ID = dbo.PROCESS.PC_ID LEFT OUTER JOIN
dbo.[PROCEDURE] ON dbo.PC_PD_REL.PD_ID = dbo.[PROCEDURE].PD_ID
WHERE (dbo.PROCESS.PC_Name = '24')