Also reproducible with comma-style join:
CREATE TABLE t1 ( f1 int ); INSERT INTO t1 VALUES (19), (20);
CREATE TABLE t3 ( f10 varchar(32) ); INSERT INTO t3 VALUES ('a'),('b');
CREATE TABLE t4 ( f10 varchar(32) ); INSERT INTO t4 VALUES ('c'),('d');
SELECT * FROM t1 WHERE ( 't' ) IN ( SELECT t3.f10 FROM t3,t4 WHERE t4.f10 = t3.f10 );
Also reproducible with comma-style join:
CREATE TABLE t1 ( f1 int );
INSERT INTO t1 VALUES (19), (20);
CREATE TABLE t3 ( f10 varchar(32) );
INSERT INTO t3 VALUES ('a'),('b');
CREATE TABLE t4 ( f10 varchar(32) );
INSERT INTO t4 VALUES ('c'),('d');
SELECT *
FROM t1
WHERE
( 't' ) IN (
SELECT t3.f10
FROM t3,t4
WHERE t4.f10 = t3.f10
);