Re: [users] SQL not working

2008-06-05 Thread Keith Clark
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"."Tit

[users] SQL not working

2008-06-05 Thread Keith Clark
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"."Na