Martin James

Martin James

  • NA
  • 100
  • 15.4k

Differences between INNER JOIN and INNER JOIN with a subquery

Apr 15 2021 11:18 AM
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)