Are you trying to get all the columns from Table2 twice each?
Or are you trying to restrict the rows returned by Table1.field1 and Table1.field2?
If what you want is all the columns from Table2 twice, then yes, you can do something like that.
If what you want is columns from Table1 and Table2, with a double restriction on it, try this:
Select *
from Table1 left join Table2 on table1.field1 = table2.field1 and table1.field2 = table2.field1
The "and" clause in the join gives you two restrictions on the join. You could also use "or" if what you want is "Table2.field1 is equal to Table1.field1 or table1.field2".
I can't quite tell from your query what the desired end result is.
The error your getting is almost certainly from the parenthesis. When you use those in a From statement, you have to include a full subquery in them and give it a name:
select *
from (select table1.*
from table1 left outer join table2
on table1.field1 = table2.field2) as Name
left join table2
on name.field2 = table2.field1
"Name" in this case is a named sub-query which would have all the fields from table1 in it. (In MS SQL, you can ommit the "as" before the subquery name, so you can probably do the same in Access, but I'm not certain on that point.)
Please let me know if that helps. If you can clarify what you are trying to accomplish with the query, I can provide more specific advice.