Which query design is better?

[wvandenberg]

I have two queries:


query1

SELECT DISTINCT tblImportALS.ANALYTE, tblAnalytes.AnalyteName, tblGroups.GroupDescription, tblReportingUnits.ReportingUnitsDescription, tblAnalytes.pkAnalyteID, tblAnalytes.ParentAnalyteID
FROM tblImportALS INNER JOIN (tblReportingUnits INNER JOIN (tblAnalytes INNER JOIN tblGroups ON tblAnalytes.fkLabGroupID = tblGroups.pkGroupID) ON tblReportingUnits.pkReportingUnitsID = tblAnalytes.fkReportingUnitsID) ON (tblImportALS.UNITS = tblReportingUnits.ReportingUnitsDescription) AND (tblImportALS.PCODE = tblGroups.GroupDescription) AND (tblImportALS.ANALYTE = tblAnalytes.AnalyteName);

query2

SELECT DISTINCT tblImportALS.ANALYTE, tblAnalytes.AnalyteName, tblGroups.GroupDescription, tblReportingUnits.ReportingUnitsDescription, tblAnalytes.pkAnalyteID, tblAnalytes.ParentAnalyteID
FROM tblImportALS, (tblReportingUnits INNER JOIN tblAnalytes ON tblReportingUnits.pkReportingUnitsID = tblAnalytes.fkReportingUnitsID) INNER JOIN tblGroups ON tblAnalytes.fkLabGroupID = tblGroups.pkGroupID
WHERE (((tblAnalytes.AnalyteName)=[ANALYTE]) AND ((tblGroups.GroupDescription)=[PCODE]) AND ((tblReportingUnits.ReportingUnitsDescription)=[UNITS]));

Both queries produce the same results but I don't know which one is better/faster?

Any suggestions?

Thanks,
Wendy

 

[dhookom]

It is my understanding that joins are more efficient in JET and SQL Server. I expect there might be some dependency on indexing of the fields contained in the joins/criteria.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[wvandenberg]

Thanks Duane.

I'll go with Query1.

Wendy