56,677
社区成员
发帖
与我相关
我的任务
分享
-- NewCol=显示列,ID=两表的关联列,为vi_res_site.id唯一列,bs_res_site为引用可重复,Date=修改时间
select
*
,ifnull(b.COl,a.COl) as NewCOl
from vi_res_site AS a left JOIN bs_res_site AS b ON a.ID=b.ID and b.Date=(SELECT max(Date) FROM bs_res_site WHERE ID=b.ID);
select
*
,ifnull(b.COl,a.COl) as NewCOl
from vi_res_site AS a left JOIN bs_res_site AS b ON a.ID=b.ID and Date=(SELECT max(Date) FROM bs_res_site WHERE ID=b.ID);