Is it possible to join derived tables to actual tables in Access 2007 like in SQL Server 2008? I have an example below:


  

      SELECT * 
        FROM 
        --MyOtherTable is a "real" table
        MyOtherTable INNER JOIN
        --MyTable is a "real" table. MyDerivedTable is a "pseudo" table derived from MyTable
        (SELECT * FROM MyTable WHERE MyID >10) AS MyDerivedTable ON
        MyOtherTable.ID = MyDerivedTable.ID


is this possible in Access? The reason I am asking is because I would like to migrate some of my SQL Server 2008 queries into Access but most of my queries contain a lot of derived tables and I haven't been able to convert my queries if they require the use of a derived table.