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 = '化妆品'