Why do the following two queries fail to find the printer makers?

Posted by ovr on Stack Overflow See other posts from Stack Overflow or by ovr
Published on 2010-06-08T19:19:19Z Indexed on 2010/06/08 19:22 UTC
Read the original article Hit count: 215

Filed under:

alt text

In this schema, why do the following two queries fail to find the printer makers?

select distinct maker from product
where model in (select model from printer)

and this:

select distinct maker from product, printer
where product.model = printer.model

© Stack Overflow or respective owner

Related posts about sql