Which should be preferable considering query cost ? joins should be used in sql queries OR Inner query(sub queries) is best.

Question

according to me inner queries are more efficient than joins

Answer 1

Both has benefits and drawbacks, freely use either one as necessary, neither one of them is a definite solution to any purpose.

Hth, cmiiw