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
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