>Even more interesting to me is:
>How can I know which will run once and which will really be a correlated subquery?
You can find out if you use code from
Re: How to use select... where EXISTS ... ? Thread #
793069 Message #
793141 but instead of counting write log records using STRTOFILE(). The correlated subquery is a such that references columns from the main query.
>
>Also, wouldn't both cases be run every time **IF** there was a field from the record itself included in the subquery's WHERE clause? (say like WHERE ARCODE.Activity = TAITEM.ActionCode)
What you describe is correlated subquery so it isn't applicable to the IN subquery.
--sb--