SQL: Where Vs. Inner Joins

Results 1 to 2 of 2

Thread: SQL: Where Vs. Inner Joins

  1. #1
    Join Date
    Dec 1969

    Default SQL: Where Vs. Inner Joins

    Hi ppl,<BR><BR>my site is all driven through one &#039;very&#039; intensive asp page with pretty much everything driven off the database and the "Server too Busy" message is far from funny so I need to pick the hell out of the code.<BR><BR>Firstly many many thanks for this 4guysfromrolla network, you guys have everything an ASP programmer could ever need (well me so far anyway).<BR><BR>My question is a pretty simple one, but I haven&#039;t found anything on it: What&#039;s the difference (mainly performance-wise) of simply using a WHERE statement to pick data from two databases and using an INNER JOIN statement???<BR><BR>eg. SELECT * FROM table1, table2 WHERE table1.column = table2.column;<BR> AND <BR>SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;<BR><BR>Thanks,

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default They are the same

    The first way is not really the ANSI standards but in terms of preformance i would get out on a limb and say they are the same.<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