SELECT from table with Varying IN list in WHERE clause
Your requirement is called as Varying IN-lists. See Varying IN list of values in WHERE clause Reason : IN (‘1, 2, 3’) is NOT same as IN (1, 2, 3) OR IN(‘1’, ‘2’, ‘3’) Hence, SELECT * FROM temp_id WHERE data_id IN(SELECT ids FROM temp); is same as SELECT * FROM temp_id WHERE data_id IN(‘1, … Read more