On Fri, 2008-06-06 at 00:33 -0400, Keith Clark wrote: > 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'
Ok, it was late, never mind. I found my error and I'm too embarrassed to let you know what it was. Good evening. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
