Access sql with python, please. I'm desperate

sdd daniels at dsl-only.net
Fri Nov 14 09:51:33 EST 2003


Alex Martelli wrote:
> sdd wrote:
>>    SELECT * FROM (SELECT age, weight FROM personnel)
>>    WHERE age IN (SELECT age FROM retirees)
> 
> ...I'm not sure why you want the FIRST of the two nestings here --
> why not just one nesting, as in:
>     SELECT age, weight FROM personnel
>     WHERE age in (SELECT age FROM retirees)
> ?
There is no value to the nesting; I was simply trying to
echo the pattern the original poster's nested query in a
syntactically correct way.  The fillip was in adding the
plausibly reasonable second subquery.

-Scott David Daniels
Scott.Daniels at Acm.Org





More information about the Python-list mailing list