quote:

---

More info please. Post DDL, and what you are tryig to accomplish.

-Chad

---

SELECT ir.[STOCK NUMBER], ir.[UNIT OF ISSUE], ir.[SERVICEABLE BALANCE], 
ir.NOMENCLATURE, ir.ERRCD, ir.[RID], ir.[MISSION IMPACT CODE], 
ir.[EEX CODE], ir.[DATE SPC ASSIGNED], ir.[UNIT PRICE], ir.[ISG NBR] 

FROM [item record]ir 
where EXISTS (Select 1 from [due out detail] do where ir.[sran] = do.[sran] AND 
ir.[stock number] = do.[stock number] and
ir.[SYS DESIG]='01'AND ir.[BUDGET CODE]='9'AND 
ir.[SERVICEABLE BALANCE]>'0'AND ir.[BENCH STOCK RCD FLAG]='0'AND 
ir.[FIXED LEVEL FLAG]='0'AND ir.[RBL FLAG]='0'AND 
ir.[MAX LEVEL FLAG]='0'AND ir.[SUPP ADJUNCT RCD FLAG]='0'AND 
ir.[STOCKAGE PRIORITY CODE]='5'AND ir.[MIN LEVEL FLAG]='0') 
or exists
(Select 1 from [adjusted level detail] ad where ir.[sran] = ad.[sran] AND 
ir.[stock number] = ad.[stock number] and
ir.[SYS DESIG]='01'AND ir.[BUDGET CODE]='9'AND 
ir.[SERVICEABLE BALANCE]>'0'AND ir.[BENCH STOCK RCD FLAG]='0'AND 
ir.[FIXED LEVEL FLAG]='0'AND ir.[RBL FLAG]='0'AND 
ir.[MAX LEVEL FLAG]='0'AND ir.[SUPP ADJUNCT RCD FLAG]='0'AND 
ir.[STOCKAGE PRIORITY CODE]='5'AND ir.[MIN LEVEL FLAG]='0')