假设S为采购询价明细清单表,如需查询所有采购员甲及采购员乙的询价明细,以下SQL语句正确的是?
A:SELECT * FROM R WHERE 询价人员=‘采购员甲’ AND 询价人员=‘采购员乙’
B:SELECT * FROM R WHERE 询价人员=采购员甲 AND 询价人员=采购员乙
C:SELECT * FROM R WHERE 询价人员=‘采购员甲’ OR 询价人员=‘采购员乙’
D:SELECT * FROM R WHERE 询价人员=采购员甲 OR 询价人员=采购员乙
发布时间:2024-05-15 11:06:50