更新时间:2023-02-05 23:37:31
您可以尝试 JOIN 它们(将它们链接在一起)或使用 UNION(将两个选择合二为一);
You could try to either JOIN them (Linking them together) or use UNION (Combine two selects in one);
http://dev.mysql.com/doc/refman/5.0/en/join.html
select a.col1, b.col1
from table1 a
inner join table2 b on a.id = b.id;
http://dev.mysql.com/doc/refman/5.0/en/union.html
select name as col1, surname as col2 from table1
union
select location as col1, desc as col2 from table2;
约翰