select a.*,b.* from Buy_Listing a , Supply_Listing b
where a.Details like '%笔记本%' and b.Details like '%笔记本%' order by a.UpdateTime desc,a.Weight asc,b.UpdateTime desc,b.Weight asc
where a.Details like '%笔记本%' and b.Details like '%笔记本%' order by a.UpdateTime desc,a.Weight asc,b.UpdateTime desc,b.Weight asc
union all
select b.* from Supply_Listing b where b.Details like '%笔记本%'
order by a.UpdateTime desc,a.Weight asc,b.UpdateTime desc,b.Weight asc
即可
union all
select b.* from Supply_Listing b where b.Details like '%笔记本%'
order by UpdateTime desc,Weight asc,UpdateTime desc,Weight asc
即可。