'Bushism'/Idiocy of the Day
Registered User
Joined: Mar 2001
Posts: 50,370
Likes: 0
From: All over SoCal
SELECT
ITEM.ITEM_ID,ITEM.MASTER_ITEM_ID,ITEM.MASTER_ITEM_ DESC,ITEM.ITEM_SUBJECT,ITEM.BARCODE,ITEM.ITEM_REF, ITEM.ITEM_DESC,ITEM.VOLUMENO,ITEM.CL_DESCRIPTION,I TEM.PERMANENTLOCATION,ITEM.CURRENTLOCATION,ITEM.OF FICE_DESC,ITEM.STATUS_DESC,ITEM.VENDOR_BARCODE,ITE M.CHECKOUT_STATUS,ITEM.S_CL_DESCRIPTION,ITEM.PLOC_ ID,ITEM.CLOC_ID,ITEM.HAS_ATTACHMENT,ITEM.IS_E_RECO RD
FROM ITEM
INNER JOIN (SELECT ITEM_ID_C,C_RELATION AS RELTYPE FROM ITEMREL WHERE ITEM_ID_P = 199898 AND RELATION_TYPE = 1 ) IR ON ITEM.ITEM_ID = IR.ITEM_ID_C
ITEM.ITEM_ID,ITEM.MASTER_ITEM_ID,ITEM.MASTER_ITEM_ DESC,ITEM.ITEM_SUBJECT,ITEM.BARCODE,ITEM.ITEM_REF, ITEM.ITEM_DESC,ITEM.VOLUMENO,ITEM.CL_DESCRIPTION,I TEM.PERMANENTLOCATION,ITEM.CURRENTLOCATION,ITEM.OF FICE_DESC,ITEM.STATUS_DESC,ITEM.VENDOR_BARCODE,ITE M.CHECKOUT_STATUS,ITEM.S_CL_DESCRIPTION,ITEM.PLOC_ ID,ITEM.CLOC_ID,ITEM.HAS_ATTACHMENT,ITEM.IS_E_RECO RD
FROM ITEM
INNER JOIN (SELECT ITEM_ID_C,C_RELATION AS RELTYPE FROM ITEMREL WHERE ITEM_ID_P = 199898 AND RELATION_TYPE = 1 ) IR ON ITEM.ITEM_ID = IR.ITEM_ID_C
to the 
