topic Re. :how to create a SQL Statement with two subquery level in QlikView

how to create a SQL Statement with two subquery level

Tue, 27 Jul 2010 12:07:22 GMT

Hi there,

I'm using the QVOlapConnetor and the QVSapQueryConnector and I would like the create a SQL statement with two level of subqueries.

For example:

Select C

From T1

where A IN (

Select A From T2 where B IN (

Select B From T3

)

It seems to work fine just for one level subselect.

Any Suggestion?

Thanks a lot in advance

Re. :how to create a SQL Statement with two subquery level

martin59 — Tue, 27 Jul 2010 14:07:31 GMT

Hi,

Hope it helps you


T3:
LOAD B;
SQL SELECT B FROM T3;
T2:
LEFT KEEP (T3)
LOAD A, B;
SQL SELECT A, B FROM T2;
T1:
LEFT KEEP (T2)
LOAD A, C;
SQL SELECT A, C FROM T1;

DROP TABLE T2, T3;
DROP FIELD A;

Re. :how to create a SQL Statement with two subquery level

Tue, 27 Jul 2010 17:18:59 GMT

thanks Martin, but the problem is that I need to limit the dataset at SAP Side because the dataset is very huge and then I can't load the data in QV and after perform a left keep so my question is about how to send a SQL Statement to SAP but I don't know the right syntax to apply (is not SQL standard nor SQL Oracle)