> select
> "book_id"
> from
> "bookgenres",
> "genre_children"
> WHERE
> "bookgenres"."genre_id" = "genre_children"."genre_child_id" AND
> "genre_children"."genre_id" = 1345

On a total-non-related thingy...

Drop the double quotes - don't use them, ever, and you don't
have to use them everywhere.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com