sql error

------=_NextPart_000_02A6_01C42D48.D80C3370
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi: I am getting the following error when I run sql query

mysql> SELECT ipaddress FROM ip_via_pingsweep WHERE ipaddress NOT IN =
(SELECT ipaddress FROM object_subips);
ERROR 1064: You have an error in your SQL syntax. Check the manual that =
corresponds to your MySQL server version for the right syntax to use =
near 'SELECT ipaddress FROM object_subips)' at line 1

The following 2 queries are fine:
mysql> select ipaddress FROM ip_via_pingsweep;
Empty set (0.00 sec)

mysql> SELECT ipaddress FROM object_subips;
Empty set (0.00 sec)

Any ideas?

TIA
Ravi
------=_NextPart_000_02A6_01C42D48.D80C3370--