Many to many relation. How?

[Ralf Sander]

Hi Ruslan,

Could you give me a little hint on this issue too, please?

> * Finally, in RDBMS model, to get M : M link you must to have third 
> table.

OK, lets assume, I have 3 tables.
t1:
1 John
2 Bob


t2:
1 personid1 taskid1
2 personid1 taskid2
3 personid1 taskid3

t3:
1 task1
2 task2
3 task3

How will the select statement look here, if I want to get all tasks in 
t3, that are related to record 1 in t1?

Thanks,
Ralf