|
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 |
- [RBG7-L] - Re: Project and sub-select with distinct John Engwer
- [RBG7-L] - Re: Project and sub-select with distinct David M. Blocker
- [RBG7-L] - Re: Project and sub-select with distinct Lawrence Lustig
- [RBG7-L] - Re: Project and sub-select with disti... John Engwer
- [RBG7-L] - Re: Project and sub-select with d... Albert Berry
