Question

SQL语句查询同一字段满足多个值如何写呢？

请问下高手：ACCESS表中，有个表tel中一字段名为phone，有如下值：0773，0775，0675，0755，020...，如果用SQL语句查询同时满足条件：0773和0775 的语句该怎么写？这样可以吗：select * from tel where phone =0773 and phone=0775 order by num desc ?

Answer 1

可以、
select * from tel where phone in('0773','0775') order by num desc

Answer 2

查询得到的数据需要如下老公 lg年龄 lg月薪 老婆 lp年龄 lp月薪 合计年龄 合计工资张某 27 500 李某 26 800 53 1300 select 老公,a.年龄 as lg

Answer 3

select * from tel where phone =0773 or phone=0775 order by num desc

Answer 4

把AND改成OR