Re^2: Many-to-many relationships in databases

Just convert everything to upper case. Far more efficient than using LIKE unnecessarily.

SELECT book
FROM   BooksAuthors AS B1
JOIN   BooksAuthors AS B2
ON     B1.Book = B2.Book
WHERE  UPPER(B1.Author) = 'JONES'
AND    UPPER(B2.Author) = 'SMITH'
[download]

--
<http://dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg

Comment on Re^2: Many-to-many relationships in databases Download Code