怎样用LEFT JOIN ON与RIGHT JOIN ON?

lingchen 发布于 2008-03-13 18:50， 1025 次点击

如题,不知道这种查询是怎样的用法,还请各位指教!

1 回复

lff6422008-03-14 17:22

select A.col_1,B.col_1 from Table_1 A left join Table_2 B on A.col_2=B.col_2

select A.col_1,B.col_1 from Table_1 A right join Table_2 B on A.col_2=B.col_2