从商品类型表和商品表中查询化妆品的商品编号和商品名称。
A.
select shopid , shopname from shoptype inner join shop where shoptypename = '化妆品'
B.
select shopid , shopname from shoptype left join shop on shoptype . shoptypeid = shop . shoptypeid where shoptypename = '化妆品'
C.
select shopid , shopname from shoptype inner join shop on shoptype . shoptypeid = shop . shoptypeid where shoptypename = '化妆品'
D.
select shopid , shopname from shoptype right join shop on shoptype . shoptypeid = shop . shoptypeid where shoptypename = '化妆品'