请在 下方输入 要搜索的题目:

查询"陆以宁"购买"真彩水粉纸"的日期。以下哪句语句写法是正确的:


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
推荐参考答案 ( 由 快搜搜题库 官方老师解答 )
联系客服
答案:D
专业技术学习
专业技术学习
搜搜题库系统