difficult query (for me)

Hello

I will try to explain my problem as clearly as i can.

So, I have tree tables
Named:

Tables
Threads
Posts

It is typicall structure of discussion phorum.
Now, Tables has a column ID (unique random index)
Threads has a columns ID (index) and TableID (index of one row of tables
table)
Posts has attribute ThreadId and CreateTime

(i only wrote important columns to this query)

Now, I have Tables row with ID = 10
And then i want to have list of all Threads (belongs to Table with id = 10,
so WHERE Threads.TableId = 10) sorted by CreateTime of newest Posts row
belong to every thread.

F.E.
Table.iD = 10

Thread
ID TableID
1 10
2 10
3 11

Posts
ThreadId CreateTime (i will use nubers only to explain)
1 10
1 20
1 25
2 43
3 02

So i want to have result from Table ID = 10:
Threads
ID
2 (because CreateTime of Posts from 2 Thread is highest)
1 (and so on...)

(Thread 3 not belongs to Table.ID = 10)

Of course result can contains adequate Posts columns but don't must to...

I hope you will able to help me, i think it's not difficult but i'm a
little newbie, so, i gave up on this :PPP

Best regards
QdlatY