涉及到的表:product、printer
select maker
from product,printer
where product.model=printer.model
and color='1'
and price in (
select min(price)
from product,printer
where product.model=printer.model
and color='1'
)
解题思路:
先将两个表做连接,找出彩色打印机,再查找价格最低,*~~注意!在查找最低价格时做的嵌套查询里仍要有"color=1"~~ *这一条件!