I am trying to check a list (MyList) against another List
(SupplierList).
I want sum the Qty's of UniqueID on MyList and extract the sum of the
same UniqueId's on SupplierList.
BTW There are more than one instances of Unique Id on each list.
The Script below is providing me with the correct answer for some
products (UniqueId), but incorrect amounts for others.
The incorrect answer is always a multiple of the correct answer.
What am i doing wrong???
Regards,
Ciarán
SELECT MyList.[Unique ID], SupplierList.[Unique ID], Sum
(MyList.[SHP_QTY]), Sum (SupplierList.[Qty new])
FROM MyList LEFT OUTER JOIN SupplierList ON MyList.[Unique ID]
= SupplierList.[Unique ID]
GROUP BY MyList.[Unique ID], SupplierList.[Unique ID]