Are there any differences in term of optimization between :
- SELECT A.*,B.*
- FROM A
- INNER JOIN B ON A.ID=B.ID
- SELECT A.*,P.*
- FROM A
- INNER JOIN (
- SELECT * FROM B) AS P ON A.ID=P.ID
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amira BedhiafiPosted Apr 15, 2021, 11:29 AM