Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    7

    Unanswered: Oracle user trying MSACCESS query...

    Here's the MSACESS query:

    SELECT *
    FROM LINKED_LOCAL LEFT JOIN INVOICES ON (LINKED_LOCAL.Vendor_Site_Id=INVOICES.SITE_ID) AND (LINKED_LOCAL.Invoice_Num=INVOICES.INVOICE_NUM)

    This query takes forever... and I am not familiar with using "LEFT JOIN"...

    I interpret the above as being the following in Oracle... I even try this format in MSACESS and i get nothing returned.. .

    SELECT * FROM
    LINKED_LOCAL, INVOICES
    WHERE LINKED_LOCAL.Vendor_Site_Id=INVOICES.SITE_ID)
    AND (LINKED_LOCAL.Invoice_Num=INVOICES.INVOICE_NUM)

    Am i doing something wrong?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Have no idea if you're doing something wrong until you tell what you're trying to do ... Right now I see 2 queries that seem valid ... What are you looking for? How long is "forever"??? Oracle is a database orders of magnitude faster than Access in querying ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Just an FYI - the second query is invalid (in any system) so will be giving you error messages not empty result sets (please use cut and paste when posting code) and, even if it wasn't, they aren't equivalent. I think (bear in mind I have never written but have seen some PL\SQL) that the equivalent in Oracle (up to 9i) would be:
    Code:
    SELECT * FROM 
    LINKED_LOCAL, INVOICES
    WHERE LINKED_LOCAL.Vendor_Site_Id(+)=INVOICES.SITE_ID
    AND (LINKED_LOCAL.Invoice_Num(+)=INVOICES.INVOICE_NUM)
    However recent Oracle systems support the ANSI Left Outer Join syntax (I admit - I just looked up the bit about 9i ).
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •