Access SQL how to use a Subquery in from like you can do in Oracle

[Soda_data]

I am familiar with Oracle SQL where I am allowed to use a subquery in my from clause as a virtual table of my own making or a view of data from the real database as a virtual sql table. However, I can't figure out how to do the same thing using Access SQL in MS Access 2013. This is an example of what runs fine in Oracle SQL but I can't get the technique to work in Access SQL:

Select
mytable.one
from
(Select database_table1.field1 as one from database_table1 where database_table1.field1 = 'Apple') as mytable,
database_table2
where


mytable.one = database_table2.one

[orange]

Msaccess and subqueries see allen browne 1 and 2

[Soda_data]

Msaccess and subqueries see allen browne 1 and 2

Thank you, orange.
In the Allen Browne 1 thread I was able to use the example given for aggregation and sub query in the from.
It was a little tricky for me but it worked and I'm starting to catch on.
I appreciate your advice and this forum as well.
Today was my first time to use it.

[ItsMe]

...
Today was my first time to use it.

Welcome to the forum.

[orange]

Happy to help. And welcome to the forum.