Select {some_fields} from SalesSummary ; > into cursor cBrowse readwrite ; > ; > Where Between( period, lnFirstPeriod, lnLastPeriod) ; > And SalesSummary.CustNumber in (Select CustNumber from CustomerSummary; > where ACustClass in (select Left(DrillValue,20) from cDrillDown where Depth = 1)) ; > And SalesSummary.CustNumber in (Select CustNumber from CustomerSummary ; > where ACustID in (select Left(DrillValue,15) from cDrillDown where Depth = 2)); > group by {some_other_fields}>Two questions:
Select CustNumber from CustomerSummary; > where ACustClass in (select Left(DrillValue,20) from cDrillDown where Depth = 1); > into cursor cTemp1 > >Select CustNumber from CustomerSummary ; > where ACustID in (select Left(DrillValue,15) from cDrillDown where Depth = 2); > into cursor cTemp2 > >Select {some_fields} from SalesSummary ; > into cursor cBrowse readwrite ; >; > Where Between( period, lnFirstPeriod, lnLastPeriod) ; > And SalesSummary.CustNumber in (Select * from cTemp1) ; > And SalesSummary.CustNumber in (Select * from cTemp2 ); > group by {some_other_fields}