Using subselects in dataset query

[Puneet09]

Hi All,

I am new to Jasper reports, and I'm stuck with a problem.

I am writing a query like

SELECT X.value1, T1.value2
FROM T1, (Select  value1 from T2, T3 where ..... ) X
Where
............................

But report designer won't let me write query like this. It complains for this subselect part.

Is there a way I can use these queries.

Thanks in advance.

[rajesh.sirsikar]

Hi,

Please refer to the below blog link:

http://www.rajeshsirsikar.com/using-subselect-in-sql-query-in-jaspersoft-studio/

regards,

Rajesh