Re: MS/ACCESS SQL -> ORACLE SQL

On Sat, 29 Sep 2001, anon_at_anon.com wrote:

> 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

-- 
Galen Boyer
I have nightmares about Tinky Winky beating me with his red bag.