List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 4 1999 7:43pm
Subject:Re: Sub-selects IN()
View as plain text  
David Wall wrote:
> 
> According to the documentation I have, sub SELECTs via the IN() function may
> be available in 3.23.2.  I'm running 3.22.21.  I'm trying to figure out how
> much coding work-around I should do since subselects aren't available yet.
> Does anybody know if subselects really will be parat of 3.23.2, and if so,
> when that may become available?
> 
> Thanks,
> David
> d.wall@stripped
> 

You can always reduce a sub-select to two queries , one
storing the results in a temporary table, the other
doing a join with the temporary table.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
Sub-selects IN()David Wall4 Jun
  • Re: Sub-selects IN()Sasha Pachev4 Jun
    • Re: Sub-selects IN()Paul DuBois5 Jun
  • Re: Sub-selects IN()David Wall5 Jun
    • Re: Sub-selects IN()Paul DuBois5 Jun