Compare performance between Sub Query and SQL subquery

I always create Access Query oject which join between Table and another Sub
Query object. I think by using this way, It is easier to build a complex
query than using SQL subquery.

But now, I have to care about performance. So, I would like to ask you ,
Which method is better in performance.

TIA,
Malee



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 08/10/2004

Hi,

In theory sub-query can be optimize knowing the whole problem, but in
practice, it is often observable that a solution based on embedded queries
run faster. Go for maintenance first, then optimize for speed, by testing
alternatives, if it is required. Note that correlated sub-query cannot be
simulated through embedded queries.


Hoping it may help,
Vanderghast, Access MVP

"Malee" wrote in message
...
I always create Access Query oject which join between Table and another Sub
Query object. I think by using this way, It is easier to build a complex
query than using SQL subquery.

But now, I have to care about performance. So, I would like to ask you ,
Which method is better in performance.

TIA,
Malee



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 08/10/2004