RE: (OT) access to oracle sql

["Keith Doxey" <ukha@xxxxxxxxxxx>]

Hi Aashram,

Oracle DOES support Left and Inner joins but not in the same way...

ACCESS

SELECT Whatever
FROM TableA INNER JOIN TableB ON TableA.SomeField = TableB.SomeOtherField
WHERE SomeCondition

ORACLE

SELECT Whatever
FROM TableA, TableB
WHERE TableA.SomeField = TableB.SomeOtherField
AND SomeCondition

...etc

Left Joins are done a similar way but you put a "+" against one
of the
tables which will always return records from that table even if there isnt
a
record in the other table.

Cant remember the exact syntax because my Oraclebooks are at work and I am
not.

I mainly used Access, MS SQL and MySQL where I have a choice but do have to
work with Oracle  a lot of the time.

Oracle is very powerful but has some strange ways of doing things !!!!

Dont know of a tool that will do it for you so it looks like its time for
some recoding.

Hope that helps

Keith


> -----Original Message-----
> From: aashram [mailto:groups@xxxxxxx]
> Sent: 27 August 2004 09:24
> To: ukha_d@xxxxxxx
> Subject: [ukha_d] (OT) access to oracle sql
>
>
> I am moving over to oracle from access and need convert a load of
> queries. I am moving to oracle 8i which does not support left
> join, inner join etc.
>
> Is there a tool out there I can just but the access query into
> and it will convert the sql ?
> queries are quite complex so it will take me ages to do it manually.
>