Hi,

> This is a temporary DB (I am still considering between MySQL,
> PostgreSQL and Firebird), I won't really use them, they were somehow
> created when I was importing data. But thanks for the notice =).

Ah yes, if you create your objects like:

CREATE TABLE "books" - then they will become case sensitive. Like
in your case.

In mine, and many others, eyes, a pain in the *ss...

:-)

--
Martijn

> >> select
> >> "book_id"
> >> from
> >> "bookgenres",
> >> "genre_children"
> >> WHERE
> >> "bookgenres"."genre_id" = "genre_children"."genre_child_id" AND
> >> "genre_children"."genre_id" = 1345
>
> MT> On a total-non-related thingy...
>
> MT> Drop the double quotes - don't use them, ever, and you don't
> MT> have to use them everywhere.
>
> MT> With regards,
>
> MT> Martijn Tonies
> MT> Database Workbench - developer tool for InterBase, Firebird, MySQL

MS SQL

> MT> Server.
> MT> Upscene Productions
> MT> http://www.upscene.com