SQLServer中有这样的语句:
SELECT
a.col1, b.col1, b.col2
FROM ta a
CROSS APPLY (
SELECT
tb.col1, tb.col2
FROM tb
WHERE tb.col3 = a.col1
)b
GROUP BY a.col1;
这样的语句,mysql怎么实现??
SELECT
a.col1, b.col1, b.col2
FROM ta a
CROSS APPLY (
SELECT
tb.col1, tb.col2
FROM tb
WHERE tb.col3 = a.col1
)b
GROUP BY a.col1;
这样的语句,mysql怎么实现??
FROM tb b inner join ta a on b.col3 = a.col1CROSS APPLY:类似INNER JOIN
FROM tb b inner join ta a on b.col3 = a.col1