Equivalent of the Oracle In (select *)
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Does anyone know how to do the equivalent of the Oracle In within Access
SQL?
Oracle will let me do:
delete from TAble_a where (f1,f2) in (select f1,f2 from Table_b)
This incredibly useful syntax lets me tell Oracle to essentally join table a
and b then thow away all the matching rows in table a. Access will delete on
a join but will only let me do so if f1 and f2 are the primary keys.
Thanks in advance,
Maurice
.
Relevant Pages
- Re: Equivalent of the Oracle In (select *)
... Charset: noconv ... This incredibly useful syntax lets me tell Oracle to essentally join table a and b then thow away all the matching rows in table a. ...
(microsoft.public.access.queries) - Re: Limit of 1050 columns for ANSI joins
... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
(comp.databases.oracle.server) - Re: I cant find a SETUP.EXE in the SQL Plus Client ??
... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
(comp.databases.oracle.tools) - Re: How to convince my customer to use SQL2005 instaed of Oracle10g
... the old Sql versus Oracle debate. ... If I were you I would focus one SQL Server 2005 clearest advantages ... You mentioned Availability, so I assume your looking into HA (high ...
(microsoft.public.sqlserver) - Re: How to convince my customer to use SQL2005 instaed of Oracle10g
... migration to Sql 2005 would be direct & straight forward, quick, and ... If I were you I would focus one SQL Server 2005 clearest advantages ... would need a 4 processor license but for Oracle you would need a 16 ... You mentioned Availability, so I assume your looking into HA (high ...
(microsoft.public.sqlserver) |
|
