34,576
社区成员
发帖
与我相关
我的任务
分享
select a.CompanyDetails,a.Keyword,a.KeywordTitle,a.KeywordContent,a.AddTime,b.CompanyTitle,b.CompanyContent,b.CompanyName,b.www from((select Keyword.CompanyDetails,Keyword,KeywordTitle,KeywordContent,Keyword.AddTime from Keyword where Keyword.Keyword like '%眼镜%')a right join (select Companyxinxi.CompanyDetails,CompanyTitle,CompanyContent,CompanyName,Companyxinxi.www from Companyxinxi where CompanyTitle like '%眼镜%' or CompanyName like '%眼镜%')b on a.CompanyDetails=b.CompanyDetails)order by a.Addtime desc