J
JMFedchak
Guest
As suggested here is the SQL:
SELECT [tblUPC LIST2001].UPC, [PRICELIST STYLES 2000].[PRICE LIST STYLE#], [PRICELIST STYLES 2000].[PRICE EACH], tblSTYLEDESCRIPTIONS.prod_include, [PRICELIST STYLES 2000].[STATUS CODE], [PRICELIST STYLES 2000].SIZESOFFERED, [PRICELIST STYLES 2000].SIZECODE, [PRICELIST STYLES 2000].UNITOFMEASURE, [BAGPKG TABLE].BAGQTYPERCTN, [tblPCK STYLE].PACKGSTYLE, [BOXES TABLE].[BOX SIZE], [PRICELIST STYLES 2000].PHOTO, [PRICELIST STYLES 2000].SKETCH, tblSTYLEDESCRIPTIONS.FINALNAME, [Country Origin Table].CountryofOrigin, [CONTENTLABEL TABLE].LABELCONTENTA, [STYLES WEIGHT TABLE].ACCTNWIDTH, [STYLES WEIGHT TABLE].ACCTNLENGTH, [STYLES WEIGHT TABLE].ACCTNHEIGHT, [STYLES WEIGHT TABLE].ACCTNWT, [PRICELIST STYLES 2000].ORDERQTY, [STYLES WEIGHT TABLE].PACKGSTYLE, [STYLECOMPONENTS TABLE].STYCOMPONENT1, [STYLECOMPONENTS TABLE].STYCOMPONENT2, [STYLECOMPONENTS TABLE].STYCOMPONENT3, [STYLECOMPONENTS TABLE].STYCOMPONENT4, [STYLECOMPONENTS TABLE].STYCOMPONENT5, [STYLECOMPONENTS TABLE].STYCOMPONENT6, [STYLECOMPONENTS TABLE].STYCOMPONENT7, [STYLECOMPONENTS TABLE].STYCOMPONENT8, [CONTENTLABEL TABLE].CAREINSTRUCTNS1, [CONTENTLABEL TABLE].CAREINSTRUCTNS2, [CONTENTLABEL TABLE].CAREINSTRUCTNS3, [CONTENTLABEL TABLE].CAREINSTRUCTNS4, [CONTENTLABEL TABLE].CAREINSTRUCTNS5, [CONTENTLABEL TABLE].CAREINSTRUCTNS6, [CONTENTLABEL TABLE].CAREINSTRUCTNS7, [CONTENTLABEL TABLE].CAREINSTRUCTNS8, [STYLES WEIGHT TABLE].DEPTH, [STYLES WEIGHT TABLE].WIDTH, [STYLES WEIGHT TABLE].[LENGTH/HEIGHT], [STYLES WEIGHT TABLE].HEADERWIDTH, [STYLES WEIGHT TABLE].HEADERHEIGHT, [STYLES WEIGHT TABLE].NETWTLB, [LINE NAMES].[LINE NAME], *
FROM ((((([LINE NAMES] INNER JOIN [PRICELIST STYLES 2000] ON [LINE NAMES].LINEABBRV = [PRICELIST STYLES 2000].LINEABBRV) INNER JOIN (([BOXES TABLE] INNER JOIN [BAGPKG TABLE] ON [BOXES TABLE].[ITEM#] = [BAGPKG TABLE].[BAGMaster ctn]) INNER JOIN [tblPCK STYLE] ON [BAGPKG TABLE].ID = [tblPCK STYLE].ID) ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [BAGPKG TABLE].[STYLE#]) INNER JOIN ([Country Origin Table] INNER JOIN ([STYLECOMPONENTS TABLE] INNER JOIN ([CONTENTLABEL TABLE] INNER JOIN [STYLE COUNTRY ORIGN CONTENT TABLE] ON [CONTENTLABEL TABLE].CONTENTLABELCODEA = [STYLE COUNTRY ORIGN CONTENT TABLE].CONTENTLABELCODEA) ON [STYLECOMPONENTS TABLE].[PRICE LIST STYLE#] = [STYLE COUNTRY ORIGN CONTENT TABLE].[PRICE LIST STYLE#]) ON [Country Origin Table].CountryAbbrev = [STYLE COUNTRY ORIGN CONTENT TABLE].CO) ON ([PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [STYLECOMPONENTS TABLE].[PRICE LIST STYLE#]) AND ([PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [STYLE COUNTRY ORIGN CONTENT TABLE].[PRICE LIST STYLE#])) INNER JOIN [STYLES WEIGHT TABLE] ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [STYLES WEIGHT TABLE].[STYLE#]) INNER JOIN tblSTYLEDESCRIPTIONS ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = tblSTYLEDESCRIPTIONS.[STYLE#]) INNER JOIN [tblUPC LIST2001] ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [tblUPC LIST2001].[STYLE#]
ORDER BY [PRICELIST STYLES 2000].[PRICE LIST STYLE#], [LINE NAMES].[LINE NAME];
Jean
SELECT [tblUPC LIST2001].UPC, [PRICELIST STYLES 2000].[PRICE LIST STYLE#], [PRICELIST STYLES 2000].[PRICE EACH], tblSTYLEDESCRIPTIONS.prod_include, [PRICELIST STYLES 2000].[STATUS CODE], [PRICELIST STYLES 2000].SIZESOFFERED, [PRICELIST STYLES 2000].SIZECODE, [PRICELIST STYLES 2000].UNITOFMEASURE, [BAGPKG TABLE].BAGQTYPERCTN, [tblPCK STYLE].PACKGSTYLE, [BOXES TABLE].[BOX SIZE], [PRICELIST STYLES 2000].PHOTO, [PRICELIST STYLES 2000].SKETCH, tblSTYLEDESCRIPTIONS.FINALNAME, [Country Origin Table].CountryofOrigin, [CONTENTLABEL TABLE].LABELCONTENTA, [STYLES WEIGHT TABLE].ACCTNWIDTH, [STYLES WEIGHT TABLE].ACCTNLENGTH, [STYLES WEIGHT TABLE].ACCTNHEIGHT, [STYLES WEIGHT TABLE].ACCTNWT, [PRICELIST STYLES 2000].ORDERQTY, [STYLES WEIGHT TABLE].PACKGSTYLE, [STYLECOMPONENTS TABLE].STYCOMPONENT1, [STYLECOMPONENTS TABLE].STYCOMPONENT2, [STYLECOMPONENTS TABLE].STYCOMPONENT3, [STYLECOMPONENTS TABLE].STYCOMPONENT4, [STYLECOMPONENTS TABLE].STYCOMPONENT5, [STYLECOMPONENTS TABLE].STYCOMPONENT6, [STYLECOMPONENTS TABLE].STYCOMPONENT7, [STYLECOMPONENTS TABLE].STYCOMPONENT8, [CONTENTLABEL TABLE].CAREINSTRUCTNS1, [CONTENTLABEL TABLE].CAREINSTRUCTNS2, [CONTENTLABEL TABLE].CAREINSTRUCTNS3, [CONTENTLABEL TABLE].CAREINSTRUCTNS4, [CONTENTLABEL TABLE].CAREINSTRUCTNS5, [CONTENTLABEL TABLE].CAREINSTRUCTNS6, [CONTENTLABEL TABLE].CAREINSTRUCTNS7, [CONTENTLABEL TABLE].CAREINSTRUCTNS8, [STYLES WEIGHT TABLE].DEPTH, [STYLES WEIGHT TABLE].WIDTH, [STYLES WEIGHT TABLE].[LENGTH/HEIGHT], [STYLES WEIGHT TABLE].HEADERWIDTH, [STYLES WEIGHT TABLE].HEADERHEIGHT, [STYLES WEIGHT TABLE].NETWTLB, [LINE NAMES].[LINE NAME], *
FROM ((((([LINE NAMES] INNER JOIN [PRICELIST STYLES 2000] ON [LINE NAMES].LINEABBRV = [PRICELIST STYLES 2000].LINEABBRV) INNER JOIN (([BOXES TABLE] INNER JOIN [BAGPKG TABLE] ON [BOXES TABLE].[ITEM#] = [BAGPKG TABLE].[BAGMaster ctn]) INNER JOIN [tblPCK STYLE] ON [BAGPKG TABLE].ID = [tblPCK STYLE].ID) ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [BAGPKG TABLE].[STYLE#]) INNER JOIN ([Country Origin Table] INNER JOIN ([STYLECOMPONENTS TABLE] INNER JOIN ([CONTENTLABEL TABLE] INNER JOIN [STYLE COUNTRY ORIGN CONTENT TABLE] ON [CONTENTLABEL TABLE].CONTENTLABELCODEA = [STYLE COUNTRY ORIGN CONTENT TABLE].CONTENTLABELCODEA) ON [STYLECOMPONENTS TABLE].[PRICE LIST STYLE#] = [STYLE COUNTRY ORIGN CONTENT TABLE].[PRICE LIST STYLE#]) ON [Country Origin Table].CountryAbbrev = [STYLE COUNTRY ORIGN CONTENT TABLE].CO) ON ([PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [STYLECOMPONENTS TABLE].[PRICE LIST STYLE#]) AND ([PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [STYLE COUNTRY ORIGN CONTENT TABLE].[PRICE LIST STYLE#])) INNER JOIN [STYLES WEIGHT TABLE] ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [STYLES WEIGHT TABLE].[STYLE#]) INNER JOIN tblSTYLEDESCRIPTIONS ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = tblSTYLEDESCRIPTIONS.[STYLE#]) INNER JOIN [tblUPC LIST2001] ON [PRICELIST STYLES 2000].[PRICE LIST STYLE#] = [tblUPC LIST2001].[STYLE#]
ORDER BY [PRICELIST STYLES 2000].[PRICE LIST STYLE#], [LINE NAMES].[LINE NAME];
Jean