Nested Query

[rockxc]

Hi,
I want to create the following report.
select * from ABC where createdate>=(select Startdate from XYZ where entereddate=&quot;Date Entered by User&quot and createdate<=(select Endate from XYZ where entereddate=&quot;Date Entered by User&quot

There is no relation between ABC and XYZ.
I am creating a report using web intelligence.
Thanks
rex

 

[skrandel]

I assume you are using WebI 2.7.x. You can't build subqueries in WebI 2.7. However, you could build the condition you need as a condition object in Designer and then use it in WebI.

WebI 6.1 has the ability to create what you want using &quot;advanced&quot; filters in the query panel.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com