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: 187
Filed under:
sql
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
