Hi guys,
I'm using a named SQL query to make some calculations on some data. My function uses return-scalar tags to return some integers. I was wondering if it's possible to join another table in my query, and returning that result as well?
My function looks a bit like this:
Code:
<sql-query name="do_something">
<return-scalar column="id" type="int" />
<return-scalar column="my-joined-table?" type="..." />
<![CDATA[
SELECT tn.id AS id,
FROM TestTable1 tn
LEFT JOIN TestTable2 tn2
ON (tn.test_id=tn2.id)
...
...
]]>
</sql-query>
Thanks in advance!