links for 2010-06-15
-
You can use a subquery to receive the same results in only one step:
select title, price
from titles
where price =
(select price
from titles
where title = "Straight Talk About Computers")
select title, price
from titles
where price =
(select price
from titles
where title = "Straight Talk About Computers")