IN operator doesn't parse comma separated values within a field like 1,2,4
select t1.idTable01, t1.fieldData01,
t1.fieldData02 from Table01 t1 join
Table02 t2 on t1.idTable01 =
t2.idTable02 where
FIND_IN_SET(t1.fieldData02, t2.Field01)
> 0 and t2.idTable02 = 1;