how to create a SQL Statement with two subquery level

[#1]

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

[martin59]

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;

[#3]

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)