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.
