TM1 Forum

Hi guys,
does TI support SQL commands such as :

INNER JOIN
LEFT OUTER JOIN

Thanks in advanced,

Aviad Malka

adma76 wrote:Hi guys,
does TI support SQL commands such as :

INNER JOIN
LEFT OUTER JOIN

Thanks in advanced,

Important thing to understand about that... TI does nothing with SQL commands. All they are to TI is a string of text. The SQL commands are simply passed to the SQL database (typically via an ODBC connection) and processed by that database, which then returns the records (if any) to TI for processing. Accordingly TI doesn't care at all about the SQL syntax as such; all that matters is that the database system that you're connecting to supports the commands and syntax that you incorporate into the TI process.

Thanks