mysql多表联合查询

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;