Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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)