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, 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 Help With a Query > > > > 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 > > ----------- ------------ > > CategoryName1 1 > > CategoryName2 2 > > CategoryName3 3 > > > > Table(B) > > --------- > > CategoryID ItemID > > ------------ -------- > > 1 20 > > 2 20 > > 1 20 > > 3 35 > > > > CategoryID is the common key. What I want to do is pull a list of > > CategoryNames from Table(A) where the ItemID in Table(B) = 20. I want > the > > CategoryName returned once. Every way that I have tried it, I get the > > CategoryName repeated for each entry in Table(B). > > > > Query: > > SELECT a.CategoryName > > FROM Table(A) a, Table(B) b > > WHERE a.CategoryId = b.CategoryID > > AND b.ItemID = 20 > > > > Results returned: Desired Results: > > ---------------- ----------------- > > CategoryName1 CategoryName1 > > CategoryName1 CategoryName2 > > CategoryName2 > > > > Again, any help would be greatly appreciated. > > > > -------------------------------------------------------------------------- > ---- > > Archives: http://www.mail-archive.com/[email protected]/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -------------------------------------------------------------------------- ---- > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
