when (select statement within inner join should be used)?

[learning_graccess]

I come across few examples in Google where select statements were used within inner statement. I could not understand why and for what it was being used.

It was something like this :

select * from table
inner join (select * from table1) table2 on table.........)

[alansidman]

All you need to know about joins:

http://support.microsoft.com/kb/136699