Re: Need Help With a Query

2000-09-10 Thread Alex Puritche
Gary, Something like this SELECT DISTINCT a.CategoryName FROM Table(A) a, Table(B) b WHERE a.CategoryId = b.CategoryID AND b.ItemID = 20 Sunday, September 10, 2000, 8:43:45 PM, you wrote: Gary> I am having a problem pulling what I want from a couple of tables and any Gary> help

Re: Need Help With a Query

2000-09-10 Thread Gary J. Groomer
That did it. Thanks, Gary - Original Message - From: "Tom Muck" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 10, 2000 10:50 AM Subject: Re: Need Help With a Query > Try SELECT DISTINCT a.CategoryName > FROM Table(A) a, Tab

Re: Need Help With a Query

2000-09-10 Thread Tom Muck
Try SELECT DISTINCT a.CategoryName FROM Table(A) a, Table(B) b WHERE a.CategoryId = b.CategoryID AND b.ItemID = 20 tom - Original Message - From: "Gary J. Groomer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 10, 2000 1:43 PM Subject: Need H

Need Help With a Query

2000-09-10 Thread Gary J. Groomer
I am having a problem pulling what I want from a couple of tables and any help would be greatly appreciated. Find below a simple synopsis of the two tables. Table(A) - CategoryName CategoryID --- CategoryName11 CategoryName2