MySQL Forums
Forum List  »  Newbie

Re: select ... where ... in(select ..)
Posted by: Roland Bouman
Date: August 12, 2005 05:38AM

In the mean time, you could rewrite the query, and see if it performs better:

select b.book_isbn
, b.book_title
, b.book_author
from book b
inner join publisher p
on b.book_publisher = p.publisher_id
where p.publisher_name like '%wiley%'

Options: ReplyQuote


Subject
Written By
Posted
Re: select ... where ... in(select ..)
August 12, 2005 05:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.