The reason for the syntax is that the developers are storing and passing entire subquery already.  It's used to pull the entire recordset or with an additional criterion on the where clause...

Thanks for the response AJ.

Re: Why would you want to qualify the owner.table.field in the sub-query IF there is only 1 table???  I can understand the...