I am attempting to edit code that was written by a different developer (I'm not familiar with SQL) to include a field from another table 'tblInstallSummary'. How do I edit the SQL statement to reflect this? I've bolded my attempt below but I am just getting an error.
Thanks to anyone who can help
SQL = "SELECT tblHeader.[Transaction Number], tblDetails.[Installation Order Number]," _
& "tblDetails.[Item Number], tblHeader.BP, tblDetails.[Order Quantity], tblDetails.Material, tblDetails.[Line SOI Date]," _
& "tblDetails.[Material Desc from SO line], tblHeader.[Ship-to Party]," _
& "tblHeader.[CAM: Street], tblHeader.[CAM: District], tblHeader.Region" _
& " FROM tblHeader INNER JOIN tblDetails ON tblHeader.[Transaction Number] = tblDetails.[Transaction Number]" _
& " AND ON tblInstallSummary.[TransactionNumber]" _ & " WHERE" & strCriteria & " ORDER BY tblDetails.[Item Number]"
Thanks to anyone who can help
SQL = "SELECT tblHeader.[Transaction Number], tblDetails.[Installation Order Number]," _
& "tblDetails.[Item Number], tblHeader.BP, tblDetails.[Order Quantity], tblDetails.Material, tblDetails.[Line SOI Date]," _
& "tblDetails.[Material Desc from SO line], tblHeader.[Ship-to Party]," _
& "tblHeader.[CAM: Street], tblHeader.[CAM: District], tblHeader.Region" _
& " FROM tblHeader INNER JOIN tblDetails ON tblHeader.[Transaction Number] = tblDetails.[Transaction Number]" _
& " AND ON tblInstallSummary.[TransactionNumber]" _ & " WHERE" & strCriteria & " ORDER BY tblDetails.[Item Number]"