nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter many tables in query with the same where-condition

cgm

Hello, I have an problem in the query that I use for my reports: My query is a little more complex and I'm trying to shrink it.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. A sample:Select *from table1 where person in (Select person from Persons where name like ?)join table2 on (..) where person in (Select person from Persons where name like ?)join table3 on (...) where person in (Select person from Persons where name like ?)join table4 on (...) where person in (Select person from Persons where name like ?) ...and so on Is there no easier way so that I don't need to execute the same "select-pattern" in the where clause multiple times? Can anybody help? RegardsMarco

Find more posts tagged with

Comments

Hans_vd

Not sure why you have to repeat that subselect for every table... can't you add person to the join conditions?

cgm

I need to repeat that subselect,because there are many tables, which have to be filtered by persons.The tables are very huge, so that I need to shrink them before joining. The list of persons depends on a the selection of a report parameter (choose project --> persons in project). Sorry for the bad explanation, hope you can understand what I mean.

Hans_vd

>> [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]The tables are very huge, so that I need to shrink them before joining[/color] So I ask again: Can't you add person to the join condition? I presume you want to shrink the huge tables before joining to improve performance? Well, it probably won't.