D
David Cleave
Hi all
I wanted to ask about how queries are executed in Access. Let's say you
design a query which itself contains two queries each linked through a join
field.
Does it execute both these queries first, then discard the records where the
join fields don't match? Or does it only produce records where the join
fields match in the first place?
On a similar note, when you run a query with a parameter, does it find all
records and then discard those which don’t meet the parameter, or does it
only return records which meet the parameter in the first place?
Thanks for your help
David
I wanted to ask about how queries are executed in Access. Let's say you
design a query which itself contains two queries each linked through a join
field.
Does it execute both these queries first, then discard the records where the
join fields don't match? Or does it only produce records where the join
fields match in the first place?
On a similar note, when you run a query with a parameter, does it find all
records and then discard those which don’t meet the parameter, or does it
only return records which meet the parameter in the first place?
Thanks for your help
David