Re: MS/ACCESS SQL -> ORACLE SQL

I would recommend going into Access, copying the SQL into a query sql window and viewing the query using form view to see what it means. This is much easier than trying to decipher what you have written here.

Good Luck!
Chris

"Peter Sulikowski" <anon_at_anon.com> wrote in message news:9p4frt$g9i$1_at_newsg4.svr.pol.co.uk...
> Hi - I'm migrating a piece of software that uses MS/Access/ADO in VB using
> embedded SQL to Oracle and I can't make head nor tails of Microsofts SQL
> (well the LEFT and JOIN statements anyway). Theres are absolutely dozens
of
> SQL statements in the Visual Basic sourcecode that look like this. Would
it
> be possible for one of you guru's to put this in Oracle SQL format for me
so
> I can see what you've done and thus what I'll have to do for the
translation
> for the remainder of all the SQL. I've tried to read up on the LEFT and
JOIN
> statements onl-line but just don't seem to be getting the same hitset
back.
> I'm using Oracle 8i. Here's a piece of the SQL from the MS/Access system.
> Thanks a lot in advance.
> Pete.
>
>
> SELECT Customers.CustomerNumber, Transactions.TransactionID,
> Transactions.DateCreated, Transactions.Date_Completed,
> Ammendments.AmmendmentType1, Ammendments.AmmendmentType2,
> Discounts.Discount1, Discounts.Discount2, CustomerArea.AreaNumber,
> Discounts.DiscountPriority AS Discounts_DiscountPriority_Order,
> Ammendments.AmmendmentID, CustomerArea.AreaNumber1,
> CustomerArea.AreaNumber2, CustomerArea.SalesmanNo,
> Transactions.TransactionNumber, Transactions.TransactionType FROM
(Customers
> LEFT JOIN ((Transactions LEFT JOIN Ammendments ON
Transactions.TransactionID
> = 502) LEFT JOIN (Discounts LEFT JOIN MessageNotes ON Discounts.DiscountID
=
> MessageNotes.MessageID) ON Ammendments.AmmendmentID =
Discounts.DiscountID)
> ON Customers.ID = Transactions.IDType) LEFT JOIN CustomerArea ON
> MessageNotes.MessageID = CustomerArea.AreaNumber WHERE
> (((Customers.CustomerNumber)=100)) ORDER BY Customers.Transaction_Type,
> Transactions.TransactionID, Ammendments.AmmendmentType1,
> Ammendments.AmmendmentType2, Discounts.Discount1, Discounts.Discount2,
> CustomerArea.AreaNumber, Discounts.DiscountPriority,
> Ammendments.AmmendmentID, Discounts.DiscountPriority,
> Ammendments.AmmendmentID
>
>
Received on Sat Sep 29 2001 - 20:13:35 CDT