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

posted @ 2018-06-28 23:02  菜鸟木易  阅读(75)  评论(0编辑  收藏  举报