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