select * from [tab] where a1="&xx&" or a2="&xx&" or a3="&xx&"......
太长了有简短点的查询办法吗?
"select * from [tab] where "&xx&" in (a1,a2,a3)"
温馨提示:答案为网友推荐,仅供参考
第1个回答 2006-11-03
"select * from [tab] where '"&xx&"' in (a1,a2,a3,...)"