一、关联查询
病区表
视频资源表
视频资源病区关联表
关联查询的sql语句
select v.id, v.vie_name, v.vie_url, v.vie_address, v.vie_sort, v.ward_id, w.ward_name
from yx_w_v y
left join yx_ward w on y.ward_id=w.id
left join yx_video v on y.video_id=v.id
病区表
视频资源表
视频资源病区关联表
关联查询的sql语句
select v.id, v.vie_name, v.vie_url, v.vie_address, v.vie_sort, v.ward_id, w.ward_name
from yx_w_v y
left join yx_ward w on y.ward_id=w.id
left join yx_video v on y.video_id=v.id