HiI have some problem retriving records from a sql query, and could use some help. I have this query...SELECT dbo.tbl_MyTB_Node_Loc.PDI_Name, dbo.tbl_MyTB_Answer.ProtocolID, dbo.tbl_MyTB_Aproval_Loc.Description, dbo.tbl_MyTB_MeasureNames_Loc.MeasureName, dbo.tbl_MyTB_Node_Loc.LangID, tbl_MyTB_MeasureNames_Loc_1.MeasureName AS Expr2, tbl_MyTB_Aproval_Loc_1.Description AS Expr3FROM dbo.tbl_MyTB_Answer INNER JOIN dbo.tbl_MyTB_Node_Loc ON dbo.tbl_MyTB_Answer.NodeID = dbo.tbl_MyTB_Node_Loc.NodeID LEFT OUTER JOIN dbo.tbl_MyTB_Aproval_Loc AS tbl_MyTB_Aproval_Loc_1 ON dbo.tbl_MyTB_Answer.VisualDamage_ID = tbl_MyTB_Aproval_Loc_1.AprovalID LEFT OUTER JOIN dbo.tbl_MyTB_MeasureNames_Loc AS tbl_MyTB_MeasureNames_Loc_1 ON dbo.tbl_MyTB_Answer.VisualDamage_ID_Action_ID = tbl_MyTB_MeasureNames_Loc_1.MeasureID LEFT OUTER JOIN dbo.tbl_MyTB_MeasureNames_Loc ON dbo.tbl_MyTB_Answer.Installation_Action_ID = dbo.tbl_MyTB_MeasureNames_Loc.MeasureID LEFT OUTER JOIN dbo.tbl_MyTB_Aproval_Loc ON dbo.tbl_MyTB_Answer.Installation_ID = dbo.tbl_MyTB_Aproval_Loc.AprovalIDWHERE (dbo.tbl_MyTB_Answer.ProtocolID = 1) AND (dbo.tbl_MyTB_Node_Loc.LangID = 2) AND (dbo.tbl_MyTB_Aproval_Loc.LangID = 2) AND (tbl_MyTB_Aproval_Loc_1.LangID = 2) AND (tbl_MyTB_MeasureNames_Loc_1.LangID = 2)
The different AprovalID and MeasureID can be null values, but if they are not I need to filter based on LangID. How can I change the query to work like that?Best RegardsNOTE: No need to reply to this topic, it is solved
filter based on LangID if not null
Posted - 2007-09-17 : 09:41:15
