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
