根据B表字段内容查询A表内容生成新表
比方说有1个总的视频库A表

节目名称name       视频code           栏目   
aa                               1234                    1
bb                               1235                    2
cc                                1236                    3
dd                               1237                    1
ee                               1238                    3

如何根据点播日志的B表
      视频code              点播次数 pv
         1234                          3
         1236                          3
         1237                          2
         1238                          4

去查询总表
最终希望得到一个点播详情表C
节目名称name         视频code              栏目              点播次数pv
  aa                               1234                     1                         3
  cc                                1236                      3  &n