Can't figure this out

From: Kim Lord <lordkimberly_at_comcast.net>
Date: 15 Jan 2003 13:28:48 -0800
Message-ID: <a5bfca91.0301151328.3332a0ad_at_posting.google.com>

Please help me figure out what is wrong with this sql statement:

ORA-00907: missing right parenthesis
SELECT INFO.VECTIME, RECS.LONGITUDE, RECS.LATITUDE, RECS.U, RECS.V, RECS.UPRIME, RECS.VPRIME FROM ((SELECT FK_VECTORID, LONGITUDE, LATITUDE, U, V, UPRIME, VPRIME FROM CODARVECTORDATARECS WHERE LONGITUDE BETWEEN -72.1104177493672 AND -71.8895822506328 AND LATITUDE BETWEEN 40.9166666666667 AND 41.0833333333333) RECS), ((SELECT VECTIME, VECTORID FROM CODARTOTVECINFO WHERE VECTIME BETWEEN

TO_DATE('12/6/2002 1:00:00 AM','mm/dd/yyyy hh:mi') AND
TO_DATE('12/6/2002 3:00:00 AM','mm/dd/yyyy hh:mi') AND
FK_CODARREGIONID='UCONN') INFO) WHERE RECS.FK_VECTORID = INFO.VECTORID

ORDER BY INFO.VECTIME Any help is greatly appreciated,
Kim Received on Wed Jan 15 2003 - 22:28:48 CET