title: Difference B/W, WHERE and ON in SQL join Operation
body: <p>Here is my test code for explaination</p>
  
  <pre><code>create table Test3(id integer, name varchar(100));
  insert into Test3(id, name) values(1, "Vijay");
  insert into Test3(id, name) values(2, "Sandy");
  insert into Test3(id, name) values(3, "Rohit");
  create table Test4(id integer, surname varchar(100));
  insert into Test4(id, surname) values(1, "karma");
  insert into Test4(id, surname) values(2, "sharma");
  </code></pre>
  
  <p>Here is my Queries:</p>
  
  <pre><code>select Test3.id , Test3.name , Test4.surname from Test3,Test4 where Test3.id = Test4.id;
  select Test3.id , Test3.name , Test4.surname from Test3 join Test4 on Test3.id = Test4.id;
  </code></pre>
  
  <p>Both the above query statements resulted same as below:</p>
  
  <p>1   Vijay   karma</p>
  
  <p>2   Sandy   sharma</p>
  
  <p>What is the difference in both queries internally and which one on more efficient?</p>