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 - 07:47:54 CDT
