Re: Can't figure this out

What version of ORACLE? Try removing the two extra left and right parenthesis. It should work.

 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 

• Jusung Yang

lordkimberly_at_comcast.net (Kim Lord) wrote in message news:<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 Thu Jan 16 2003 - 05:26:51 CET