Ok, I am either a moron or it is late, and I will accept either, but the following statement results in zero records even though I know entries qualify....
SELECT "tblAuthors"."LastName", "tblAuthors"."FirstName", "tblProducts"."Title", "tblProducts"."Volume", "tblOnHand"."OnHand", "tbleGenre"."Name" FROM "tblOnHand", "tblProducts", "tblAuthors", "tbleGenre" WHERE "tblOnHand"."ISBN" = "tblProducts"."ISBN" AND "tblProducts"."authorID" = "tblAuthors"."authorID" AND "tblProducts"."genreID" = "tbleGenre"."genreID" AND "tbleGenre"."Name" = 'sci-fi' --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
