Open zxdxjtu opened 9 months ago
SELECT a.n, a.m, b.y, b.z FROM ( SELECT m, n FROM table1 WHERE col1 = 'value1' ) a JOIN ( SELECT x, y, z FROM table2 WHERE col1 = 'value1' ) b ON a.m = b.x ;