Re: Complex Query Fails w/ ASP->ADO->ODBC->Oracle

From: José Lima Suárez <pplima_at_jet.es>
Date: Sun, 19 Apr 1998 00:04:39 +0200
Message-ID: <6hb7rs$d2$1@diana.bcn.ibernet.es>

Try outer-joining the query:

SELECT EMPLID

FROM     (SELECT EMPLID EMPL
                  FROM     EFFORT
                  WHERE  MONTH = 2 AND YEAR = 1998), EMPDETAIL

WHERE EMPLID = EMPL (+) AND EMPL IS NULL Avoid the use of DISTINCT Received on Sat Apr 18 1998 - 17:04:39 CDT