SQL query to QlikView with Joins - ODBC

[Anonymous]

Hello guys,

I'm having some problems with QlikView, I'm new at it, SQL SELECT it's working good but... i have a query in SQL that works perfectly but i need QlikView to execute it and I'm having no succes at it, the query in SQL is:

SELECT     a.userid,

                   d.id as cursoid,

                   c.visible,

                   c.id as disciplinaid,

                   e.roleid

FROM

     tb_log a INNER JOIN tb_user b ON a.userid=b.id

     INNER JOIN tb_course c ON a.course=c.id

     INNER JOIN tb_course_categories d ON c.category=d.id

     INNER JOIN tb_role_assignments e ON a.userid=e.userid

     INNER JOIN tb_context f ON e.contextid=f.id AND f.instanceid=c.id AND f.contextlevel=50

WHERE

    b.firstname <> 'suporte'

GROUP BY

a.userid,

d.id,

c.id,

d.name,

c.shortname

ORDER BY

a.userid,

d.id,

c.id,

d.name,

c.shortname";

I think I should use the comand ALIAS a as tb_log; ... but still, i couldn't execute the query because of the Joins and I'm using ODBC conection.

[Anonymous]

ok its quite long...

today we`re using a PHP script to do that, first connect to db then execute that query and the result is saved in a variable $students, then we use the comand while and another query like that:

please look at the attachment there is the code in PHP that i need Qlik to execute and generate a QVD in the end with the table "tb_temp_temptable"

[arvind1494]

Yes