MySQL 帮助嵌套查询和连接

Question

我有三个表:Product、PC、Laptop，具有以下架构。

Product (maker, model, type)
PC (model, speed, ram, hd, price)
Laptop (model, speed, ram, hd, screen, price)

如何检索制造商 A 生产的所有产品的型号和价格？

我试过了

SELECT * 
  FROM Product 
 WHERE maker = "A" 
  JOIN type.model,type.price;

还有这个

SELECT * 
  FROM Product 
  JOIN Laptop ON Laptop.model;

...但没有任何运气。

编辑:如果我想让它更通用，我如何显示制造商 A 生产的任何产品的型号和价格，而不仅仅是笔记本电脑和 PC？

Answer 1

(SELECT product.maker, laptop.model, laptop.price
 FROM Product 
 INNER JOIN laptop ON product.model = laptop.model
 WHERE product.maker = "A" )
UNION
(SELECT product.maker, pc.model, pc.price
 FROM Product 
 INNER JOIN pc ON product.model = pc.model
 WHERE product.maker = "A" )