my Book

Book Details

SELECT MT.title, MT.prefix, M.book_id FROM books M, book_titles MT WHERE MT.title_id = M.title_id AND MT.title_id <> AND MT.author = '' GROUP BY MT.title_id ORDER BY MT.title