mysql - Data redundancy while using IN clause -

mysql - Data redundancy while using IN clause -

why receive redundant info while using in clause:

select * table1 ab in (select x table2)

this guess because question isn't clear. seek using distinct follows:

select * table1 ab in (select distinct x table2)

that eliminate duplicate values of x, may help remove duplicate rows in resultset.

mysql