Inner join

Results 1 to 2 of 2

Thread: Inner join

  1. #1
    Charlie Bullit Guest

    Default Inner join

    I probably havn&#039t understood the potential of the inner join. Could someone explain to me the diffrence between a inner join and a connection like this:<BR><BR>SQLStmt = "SELECT * FROM Table1, Table2 Where Table1.Id = Table2.Id "<BR>Set RS = Connection.Execute(SQLStmt)<BR><BR>Would a connection with a inner join be more powerfull (faster, less demanding on the server)or can&#039t you use a inner join to connect two tables like this?

  2. #2
    Stephen Fisher Guest

    Default RE: Inner join

    I believe what you have done is the equivelent of an Inner Join in all scences.<BR><BR>From my undersytanding &#039Inner Join&#039 will not work with an Oracle Database, instead you do what you have done.<BR><BR>

Posting Permissions

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