Inner Join

Results 1 to 3 of 3

Thread: Inner Join

  1. #1
    Join Date
    Dec 1969

    Default Inner Join

    I&#039;m new to ASP and need to output the results of 3 tables within one page. I&#039;ve tried using inner join which works fine with 2 tables but gives an error when I try to open the 3rd.<BR><BR>Any help would be very much appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Inner Join

    Your question is really general, but here&#039;s the syntax:<BR><BR>SELECT * From table1 t1 INNER JOIN<BR>table2 t2 on t1.SomeColumn = t2.Somecolumn INNER JOIN<BR>table3 t3 on t1.SomeOtherColumn = t3.Column<BR><BR>This should do the trick. If this isn&#039;t clear post your table layout.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default Show us what you got.

    It is very hard to discern what the problem may be, unless you show an excerpt of the malfunct code and the resulting error message.<BR>Also, which DBMS you are using may have some impact on any proposed solution.

Posting Permissions

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