Results 1 to 2 of 2

Thread: ansi join

  1. #1
    Join Date
    Jan 2003
    Location
    China
    Posts
    38

    Question Unanswered: ansi join

    Well as for the old style like the following:

    select ... from T1, T2, T3 where T1.C1 = T2.C and T1.C2 = T3.C

    I can translate it to this to match the ANSI style:

    select ... from T1 join T2 on T1.C1 = T2.C join T3 on T1.C2 = T3.C;

    But how could I translate this:

    select ... from T1, T2, T3 where T1.C = T2.C and T2.C = T3.C

    any answer is approciated. Thanks!
    Fan Yi

  2. #2
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    select ...
    from T1
    inner join T2 on T1.C = T2.C
    inner join T3 on T2.C = T3.C

Posting Permissions

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