Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Filter many tables in query with the same where-condition
Migrateduser
<p>Hello,</p><p> </p><p>I have an problem in the query that I use for my reports:</p><p> </p><p>My query is a little more complex and I'm trying to shrink it.</p><p>I'm using Report Parameter to filter my report result at runtime. Therefore I have to filter different tables in my MySQL Database with the same sub-statement.</p><p> </p><p>A sample:</p><p>Select *</p><p>from table1 where person in (Select person from Persons where name like ?)</p><p>join table2 on (..) where person in (Select person from Persons where name like ?)</p><p>join table3 on (...) where person in (Select person from Persons where name like ?)</p><p>join table4 on (...) where person in (Select person from Persons where name like ?)</p><p> </p><p>...and so on</p><p> </p><p>Is there no easier way so that I don't need to execute the same "select-pattern" in the where clause multiple times?</p><p> </p><p>Can anybody help?</p><p> </p><p>Regards</p><p>Marco</p>
Find more posts tagged with
Comments
There are no comments yet