查询"陆以宁"购买"真彩水粉纸"的日期。以下哪句语句写法是正确的:
A、
select btime from sale
join goods on sale.vno=vip.vno
join vip on goods.gno=sale.gno
where vname='陆以宁' and gname='真彩水粉纸'
B、
select btime from goods
join vip on sale.vno=vip.vno
join sale on goods.gno=sale.gno
where vname='陆以宁' and gname='真彩水粉纸'
C、
select btime from vip
join goods on sale.vno=vip.vno
join sale on goods.gno=sale.gno
where vname='陆以宁' and gname='真彩水粉纸'
D、
select btime from sale
join vip on sale.vno=vip.vno
join goods on goods.gno=sale.gno
where vname='陆以宁' and gname='真彩水粉纸'
发布时间:2024-11-27 06:55:25