query only returns 14 out of 2,000 records (1 Viewer)

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
 

jca

I need to think it over !
Local time
Today, 05:43
Joined
Aug 1, 2001
Messages
42
Check to make sure your joins are ok.
Look in your tables to see if every items as a link on the other tables. Take one of the item which is not returned by your query and verify if he is linked in every tables in the select.
 

Users who are viewing this thread

Top Bottom