I have a query wherein I need to fetch a field "Specifications" from a table "tblItemMaster" . The table is leftJoined to another table - tblPendingOrder and the key field is ItemCode in both tables. ItemCode is not a PK in either of the tables
The issue is that ItemCode has duplicates in the tblItemMaster (as we use the itemmaster also as a BOM too). Therefore if there are 2 records in tblitemmaster for an Itemcode, the query adds one extra row in the result! This is understandable
Is there a workaround that this extra row is NOT added? The "Specifications" are same in both rows for the same ItemCode, and the information of any of these records is fine in the query result!
The issue is that ItemCode has duplicates in the tblItemMaster (as we use the itemmaster also as a BOM too). Therefore if there are 2 records in tblitemmaster for an Itemcode, the query adds one extra row in the result! This is understandable
Is there a workaround that this extra row is NOT added? The "Specifications" are same in both rows for the same ItemCode, and the information of any of these records is fine in the query result!