Posts by Edhurn

    If you needed to run more than one query against this you could simply build a temp table to hold the subquery data:

    This would make no difference if you are just running the one query, but if you wanted to run more than one against the same subset it would be much quicker.