Simple: Need to add a field to SQL query. (i'm terrible)

Guys,

Need to add the field "DESCRIP" from table "TBLMANUFACTURERS" to the following query.. (last time i tried this i ended up with 16 dups of every product. It's so simple it hurts but i need to see the right way to understand..)

SELECT TBLINVENTORY.*, TBLMANUFACTURERS.NAME AS ManufName, TBLGROUPS.GROUPID, TBLGROUPS.NAME AS GroupName, TBLSHIPTIME.SHIPTIME AS ShipTimeDesc, TBLSHIPTIME.IMG AS ShipTimeImg, TBLGROUPS.DESCRIP AS GroupDescrip, TBLINV_UNITS.UNIT AS UNITNAME
FROM TBLINV_UNITS RIGHT JOIN (TBLSHIPTIME RIGHT JOIN (TBLMANUFACTURERS INNER JOIN (TBLINVENTORY INNER JOIN (TBLGROUPS INNER JOIN tblInventoryGroups ON (TBLGROUPS.GROUPID = tblInventoryGroups.GroupID) AND (TBLGROUPS.GROUPID = tblInventoryGroups.GroupID)) ON (TBLINVENTORY.ITEMID = tblInventoryGroups.ItemID) AND (TBLINVENTORY.ITEMID = tblInventoryGroups.ItemID)) ON TBLMANUFACTURERS.MANUFID = TBLINVENTORY.MANUF) ON TBLSHIPTIME.ID = TBLINVENTORY.SHIPTIME) ON TBLINV_UNITS.ID = TBLINVENTORY.UNIT
WHERE (((TBLINVENTORY.SHOWIT)=-1))
ORDER BY TBLMANUFACTURERS.NAME, TBLGROUPS.NAME;


Thanks!

SELECT TBLINVENTORY.*, TBLMANUFACTURERS.NAME AS ManufName, TBLMANUFACTURERS.DESCRIPAS ManufDesc,TBLGROUPS.GROUPID, TBLGROUPS.NAME AS GroupName, TBLSHIPTIME.SHIPTIME AS ShipTimeDesc, TBLSHIPTIME.IMG AS ShipTimeImg, TBLGROUPS.DESCRIP AS GroupDescrip, TBLINV_UNITS.UNIT AS UNITNAME
FROM TBLINV_UNITS RIGHT JOIN (TBLSHIPTIME RIGHT JOIN (TBLMANUFACTURERS INNER JOIN (TBLINVENTORY INNER JOIN (TBLGROUPS INNER JOIN tblInventoryGroups ON (TBLGROUPS.GROUPID = tblInventoryGroups.GroupID) AND (TBLGROUPS.GROUPID = tblInventoryGroups.GroupID)) ON (TBLINVENTORY.ITEMID = tblInventoryGroups.ItemID) AND (TBLINVENTORY.ITEMID = tblInventoryGroups.ItemID)) ON TBLMANUFACTURERS.MANUFID = TBLINVENTORY.MANUF) ON TBLSHIPTIME.ID = TBLINVENTORY.SHIPTIME) ON TBLINV_UNITS.ID = TBLINVENTORY.UNIT
WHERE (((TBLINVENTORY.SHOWIT)=-1))
ORDER BY TBLMANUFACTURERS.NAME, TBLGROUPS.NAME;

Well that worked (although you missed a space after TBLMANUFACTURERS.DESCRIP . I tried inserting "TBLMANUFACTURERS.DESCRIP AS MANUFDESCRIP, and for whatever reason it returned a 'not found in ordinal' error.

I've looked over your statement, am i missing another addition/change or can you tell me what might have gone wrong when i attempted it? (it seemed so simple, yet it screwed up)

Thanks.

Are you sure TBLMANUFACTURERS.DESCRIP Exists???

That is the only thing I can think of that could be wrong

S-