9. 查询提供过“iPhone 7”商品的所有供应商名及邮编
程序员文章站
2022-04-08 21:40:40
...
SELECT
vname,
vzip
FROM
product,
vendor,
recruit
WHERE
recruit.vid = vendor.vid
AND recruit.pid = product.pid
AND product.pname = 'iPhone 7';