mysql多表联合查询

A A A
SELECT o.id, o.columbia1 , o.columbia2 , i.columbia4 , i.columbia5
FROM `table1` AS i,`table2` AS o
WHERE o.columbia1 = i.columbia7 AND o.id = 2;