[Typo3-dev] sql-subset and INNER JOIN?

[Peter Niederlag]

Hello,

since db-abstraction is on the way and will be part of tYPO§ pretty soon
I do have one question about the handling of sql.

I do read
http://typo3.org/documentation/document-library/doc_core_cgl/Supported_SQL/
which tells me something about features of sql that
TYPO3-DB-wrapper(abstarction?) supports.

Is this still accurate for abstraction?
What about INNER JOIN ?

consider soemthing like this:

SELECT DISTINCT (
tx_sometable_common.pid
), tx_sometable_common. * , tx_sometable_common2.sorting
FROM tx_sometable_common
INNER JOIN tx_sometable_common AS tx_sometable_common2 ON (
tx_sometable_common.sorting = tx_sometable_common2.sorting )
LEFT JOIN pages ON pages.uid = tx_sometable_common.pid
WHERE tx_sometable_common.pid
IN ( 36, 37, 44 ) AND tx_sometable_common.deleted =0 AND
tx_sometable_common.hidden =0
GROUP BY tx_sometable_common.pid
ORDER BY pages.sorting, tx_sometable_common.sorting

Is that within supported subset?
(of course I use t3lib_db::exec_SELECTquery(...) )

would be really cool, cause I am just picking up on the magic of sql,
which can save loads of php sometimes. ;)

Thx,
Peter