2 Replies Latest reply: Jul 27, 2010 1:18 PM by gciampanelli RSS

    how to create a SQL Statement with two subquery level

      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