多表中多字段模糊查询 SQL 语句写法 多表中多字段模糊查询 SQL 语句写法表和字段为table1(ziduan1,ziduan2),table2(ziduan3,ziduan4)希望根据1个查询关键字 strKey 从多表中进行模糊查询,请写出SQL语句,谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ziduan1,ziduan2,ziduan3,ziduan4都不一样,但是希望得到两个表中的数据,按照两个新字段来保存搜索出来的数据,即table1ziduan1,ziduan2aaa cccbbb adddtable2ziduan3,ziduan4aaa2 ccc2bbb2 ddd2用a来搜索4个字段,希望得到以下结果ziduan5 ziduan6aaa cccbbb adddaaa2 ccc2 select *from (select ziduan1,ziduan2 from T1union allselect ziduan3,ziduan4 from T2)Twhere','+ziduan1+','+ziduan2 like '%,a'+'%' select * from (select ziduan1 ziduan5,ziduan2 ziduan6 from table1union allselect * from table2)b where ziduan5+ziduan6 like '%a%' SQL Server 2008 如何枚举出所有NetWork server 和 instance的? 创建数据库问题 SQL行列转换 Cannot resolve collation conflict for equal to operation sql2000一个奇怪的问题 关于连接字符串 复杂的查询 这个存储过程怎么改比较好 sql中如何通过触发器实现某列禁止修改 win2000 server 上装不了sql2000企业版?????? EXCEL向SQL中导表问题 select 没有的值
ziduan1,ziduan2
aaa ccc
bbb adddtable2
ziduan3,ziduan4
aaa2 ccc2
bbb2 ddd2用a来搜索4个字段,希望得到以下结果
ziduan5 ziduan6
aaa ccc
bbb addd
aaa2 ccc2
from
(select ziduan1,ziduan2 from T1
union all
select ziduan3,ziduan4 from T2
)T
where
','+ziduan1+','+ziduan2 like '%,a'+'%'
select * from
(select ziduan1 ziduan5,ziduan2 ziduan6 from table1
union all
select * from table2)b where ziduan5+ziduan6 like '%a%'