As long as the permissions are correct you can query across folders and projects. I see that you already discovered the syntax for doing that. The only limitations are a) user has permission to read all the tables used in the query and b) the tables are from the same datasource (underlying JDBC connection).

I'm not sure I answered your question though...