Thread: sql之left join、right join、inner join的区别
View Single Post
  #3   IP: 112.87.17.117
Old 2015-05-21, 07:04 AM
West University Place West University Place is offline
初级会员
  
Join Date: 2008-07-31
Posts: 4
West University Place 现在声名狼藉
Default
用上面提到的A、B表为例：
select * from A
left join
(
select bID,bName from B where bID <= 3
)T
on T.bID = A.aID
Reply With Quote