This is what my book catalogue says I've already got:
mysql> select bookauthors.author,books.title from books,bookauthors where books.genre='Comedy Science Fiction' and books.uid=bookauthors.uid group by books.uid order by bookauthors.author,books.title; +-----------------+-------------------------------------------------------------------+ | author | title | +-----------------+-------------------------------------------------------------------+ | Ben Elton | Stark | | Chris Howarth | Red Dwarf Programme Guide | | David Garnett | Stargonauts | | Doug Naylor | Last Human | | Douglas Adams | Dirk Gently's Holistic Detective Agency | | Douglas Adams | Mostly Harmless | | Douglas Adams | The Hitchhikers Guide To The Galaxy | | Douglas Adams | The Hitchhikers Guide To The Galaxy Omnibus | | Douglas Adams | The Long Dark Tea-Time Of The Soul | | Harry Harrison | A Stainless Steel Rat Is Born | | Harry Harrison | Bill, The Galactic Hero | | Harry Harrison | Bill, The Galactic Hero... On The Planet Of Bottled Brains | | Harry Harrison | Bill, The Galactic Hero... On The Planet Of Robot Slaves | | Harry Harrison | Bill, The Galactic Hero... On The Planet Of Tasteless Pleasure | | Harry Harrison | Bill, The Galactic Hero... On The Planet Of The Hippies From Hell | | Harry Harrison | Bill, The Galactic Hero... On The Planet Of Zombie Vampires | | Harry Harrison | Bill, The Galactic Hero... The Final Incoherent Adventure | | Harry Harrison | Star Smashers Of The Galaxy Rangers | | Harry Harrison | Technicolor Time Machine | | Harry Harrison | The Stainless Steel Rat | | Harry Harrison | The Stainless Steel Rat For President | | Harry Harrison | The Stainless Steel Rat Saves The World | | Harry Harrison | The Stainless Steel Rat Wants You | | Harry Harrison | The Stainless Steel Rat's Revenge | | Neil Gaiman | Don't Panic | | Phil Janes | Fission Impossible | | Phil Janes | The Galaxy Game | | Rob Grant | Backwards | | Rob Grant | Colony | | Rob Grant | Red Dwarf Omnibus | | Robert Rankin | Apocalypso | | Robert Rankin | Armageddon The Musical | | Robert Rankin | The Brentford Triangle | | Robert Rankin | The Fandom of the Operator | | Robert Rankin | The Greatest Show Off Earth | | Robert Rankin | The Suburban Book Of The Dead | | Robert Rankin | They Came And Ate Us | | Spider Robinson | Callahan's Crosstime Saloon | | Terry Jones | Starship Titanic | | Terry Pratchett | Only You Can Save Mankind | | Terry Pratchett | Strata | | Terry Pratchett | The Dark Side Of The Sun | +-----------------+-------------------------------------------------------------------+ 42 rows in set (0.01 sec)
I honestly didn't fix it to return 42 results ;)
I notice a couple of non-fiction books have crept in there, but I also have a couple on the shelf that I haven't entered into the database yet (the Salmon of Doubt and the Space Eater).
