Dear All,
In my following query I join tables of sales and description of itemno
SELECT TOP (100) PERCENT O.EXPDATE, O.LOCATION, M.SEGMENT2,M.SEGMENT3, O.[DESC],
SUM(O.QTYSHIPPED) AS QTY, SUM(O.UNITPRICE * O.QTYSHIPPED) AS AMT,
dbo.ICLOC.[DESC] AS Loc, M.OPTFLD5,icsegv.[desc] as...