sql

select video.videoid ,hong.name from video , hong where hong.name="小鸭" and video.hongid=hong.hongid
select a.videoid ,b.name from video a , hong b where b.name="小鸭" and a.hongid=b.hongid

select a.videoid,b.name from video a,hong b where a.hongid = b.hongid


select a.videoid,b.name from hong b left JOIN video a on a.hongid = b.hongid

原文地址:https://www.cnblogs.com/chillaxyw/p/9241289.html