[TYPO3] inner join 3 or more tables with typo3 db functions

[peter eliades]

Hello,
I need to make mysql query with inner join of three or more tables.
How can be this done with the typo3 db function exec_SELECTquery(...) ?

i.e
SELECT table1.*
FROM table1
INNER JOIN  table2 ON id1=fk2
INNER JOIN  table3 ON id2=fk3
WHERE ...
ORDER BY ...;

Thanks

-- 
Peter Eliades
Web Developer

Binary Bar s.r.o. 
Panonska cesta 17
851 04 Bratislava

mobil: +421 910 957 119
email: peter.eliades at binary-bar.com
web:   www.binary-bar.com