hello, mysql doesn't support sub-select yet...maybe in 4.1.... ;)
>mysql> select distinct(nexthop) ip from NameRoute >where OwnerIP='10.0.1.1' and >nexthop not in (select ip from NameIP where >OwnerIP='10.0.1.1'); >ERROR 1064: You have an error in your SQL syntax near >'select ip from NameIP whe >re OwnerIP='10.0.1.1')' at line 1 > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Tax Center - online filing with TurboTax >http://taxes.yahoo.com/ > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
