Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    28

    Unanswered: is this call inner join as well ?

    hi, if i have query like following

    select * from o_customer,o_address
    where
    o_customer.name = o_address.custname

    is it same as

    select * from o_customer
    inner join o_address on o_customer.name = o_address.custname


    if there are same, which one is prefer in term of performance ..

    thank you for guidance

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Former is old school, latter is current ANSI compliant.

    I would imagine the optimiser would be able to equate the two but if it didn't then number one is likely to be a dog compared to the ANSI join

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    BTW - I would use neither:

    SELECT Col1, Col2, Col3
    FROM o_customer
    INNER JOIN o_address ON o_customer.name = o_address.custname
    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
  •