ADO: JOIN vs RELATE.

[DaveO]

I posted this in the Excel programming forum, but was asked to re-post here.

I appreciate that RELATE is used when SHAPE-ing data, but I can't see a
dis-advantage of using this over a SQL statement using JOIN.

Why not always SHAPE your data using RELATE rather than ever using SQL and
JOIN?

TIA.

 

[Barry Gilbert]

Shaping data is usually only used when you want to return hierarchical data,
like if you want to fill the MSHFlexGrid. I believe it will be slower than
using standard joins if you just want a flat recordset.

Barry