Dear all, I intend to write a query to select rows based on the results from another query:
SELECT * FROM tbl1 WHERE coln1 IN (SELECT DISTINCT coln2 FROM tbl2); But this one does not work in MySQL. Anyone could help me to figure out this problem? Thanks a lot.
