Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    25

    Unanswered: Inner Join Issue

    Hi all,

    I just written an inner join statement, but would like to run another INNER JOIN against the results of the first INNER JOIN. Is this possble? If so, how?

    Thanks.

    Matt

  2. #2
    Join Date
    May 2005
    Location
    San Antonio, Texas
    Posts
    134
    think of it just like joining two tables together. It is really the same thing. You are basically joining the result set of the first join with the 3rd table.

    select * from tablea a inner join tableb b (on a.id = b.id) inner join tablec c on (b.id2 = c.id2);

    I believe this would work the same:
    select * from tablea a, tableb b, tablec c where a.id = b.id and b.id2 = c.id2

    There is also natural inner joins will give you a 'cleaner' output if the names are the same in the tables

    to do anything further you will have to give some more info This will only return results the match the 'on' restrictions in each join.

    Here is a good ref: http://en.wikipedia.org/wiki/Join_(SQL)
    Vi veri veniversum vivus vici
    By the power of truth, I, a living man, have conquered the universe

Posting Permissions

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