[mike_bike_kite]

Actually here's my first success

select   b.title, a.name
from    books b, books_authors_link al, authors a
where  al.book = b.id
             and a.id = al.author
             and b.id not in ( select book from books_ratings_link )
            and b.title in (
                      SELECT  distinct name
                     FROM     books_ratings_link rl, books_authors_link  al, authors a
                     where      al.book = rl.book
                                      and a.id = al.author
                    )

It shows all the entries where the author and title are definitely swapped over ie the book title appears as an author in an entry where that entry has a rating etc. This obviously doesn't do anything clever where the titles and author names are a little messed up but it's a good first step. This found nearly 500 matches in my little database!

Mike