Is it possible to use a sub-select with a project command?  When I execute the following project, it executes but ignores the sub-select (no errors).

 

PROJECT TEMPORARY PRICE_BK FROM UPC_MASTER +

USING MFGCODE,MFG_STYLE,MFG_DESC,W_PRICE,MARKUP,Retail_Price,In_Stock_QTY +

WHERE MFG_STYLE IN (SEL DISTINCT MFG_STYLE FROM UPC_MASTER +

WHE MFG_STYLE IS NOT NULL)

 

John

Reply via email to