SQL Subquery

Widgets

What the advantages of having lots of subquery....?

Paddy Boyd

Plenty of time to drink tea while you wait for the query to run.

Expert Coming

Having lots of subquerys will slow down your query. The more a query does the longer it will take, which makes sence right?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Vasudevan Deepak Kumar

Widgets wrote:

advantages

http://dev.mysql.com/doc/refman/5.0/en/subqueries.html[^] Adding: 1) Venting your anger on the DBA who refused to purchase a wine yesterday.

Widgets

basically there is no advantages of having sub queries...