1
Answer

Differences between INNER JOIN and INNER JOIN with a subquery

Martin James

Martin James
3y
791
1
Are there any differences in term of optimization between :
 
  1. SELECT A.*,B.*  
  2. FROM A   
  3. INNER JOIN B ON A.ID=B.ID   
and 
 
  1. SELECT A.*,P.*  
  2. FROM A  
  3. INNER JOIN (  
  4. SELECT * FROM B) AS P ON A.ID=P.ID   
Answers (1)
Next Recommended Forum