subquery

if you want to fetch multiple datatypes of data from multiple tables we can write join queries

• unnecessarily don't write any join query it will degrate your database performanceor it will decrease your query level performance
• thats why we need to write sub queries

In which case we have to write sub-queries