Set Oprator in Ms-Access

[PatelRam]

What is equivalent of Minus Operator (Oracle) in Ms-Access

??

 

[MoLaker]

I'm not too familiar with Oracle, but I don't think there is an equivalent operator in MS Access. If I understand "Minus Operator" in Oracle, it basically allows a search to be refined by lowering the rank of returned documents which contain the specified expression. MS Access is not that sophisticated (it doesn't cost near as much either).

 

[BNPMike]

From :

http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm

Use NOT EXISTS clause in your SELECT statement to generate the same result.

The following example illustrates the simulation of Oracle's MINUS operator:

SELECT OrderID, OrderDate
FROM Orders O
WHERE NOT EXISTS
(
SELECT 1
FROM RefundsTable R
WHERE O.OrderID = R.OrderID
)

 

[PHV]

Another method is to use a LEFT JOIN and testing the right side key against Null.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244