[RBG7-L] - Re: Project and sub-select with distinct

[David M. Blocker]

John   Looking at your where clause, the table in the sub-select is the same table you are projecting from.   It LOOKs the only intended efffect of the WHERE clause is to include those rows where MFG_STYLE IS NOT NULL.  If that's so, why not just say:   WHERE MFG_STYLE IS NOT NULL   That said, I'm not sure why the sub-select is being ignored!   What happens if you change the command to:   SELECT + 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)   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: John Engwer To: RBG7-L Mailing List Sent: Saturday, February 12, 2005 4:15 PM Subject: [RBG7-L] - Project and sub-select with distinct 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