Re: Define one Subquery for multiple statements

[Peter Brawley]

> I can't Change the design

Why not?

Your best alternative is to get the terms of your employment straightened out so you're a programmer rather than a clerk.

Failing that, you need to write an inefficient query, eg ...

select distinct a.id
from tbl a
join tbl b on a.column1=b.`column` and b.power between 1 and 3
join tbl c on a.column2=c.`column` and c.power between 1 and 3
join tbl d on a.column3=d.`column` and d.power between 1 and 3 ;

The query will need an index like (column,column1,column2,column3,power)