A limit to the number of SQL tables subqueries?

A limit to the number of SQL tables subqueries?

Hi Zoho,

Is there a limit to the number of SQL-created subqueries that can be used. I have no trouble making SQL based tables and then basing other queries off of them. However, I have written a series of subqueries, that are joined and suddenly it no longer seems to recognize the name of the table or query. I've checked dozens of times and tried renaming but still no luck even when I try a simple iteration.

For example:
SELECT "qryTestGreaterThanFour".CONTACTID, Tasks."Due Date" FROM Tasks LEFT JOIN Tasks.CONTACTID ON "qryTestGreaterThanFour".CONTACTID = Tasks.CONTACTID;

I get the message:  Unknown table or alias 'qryTestGreaterThanFour' used in select query.

Yet, the query is right there. 

Is there a limit to the number of queries that can be joined together.

Thanks,
Kim