I am have a database that contians stores and all of the stores attributes. What I am trying to do is pull store numbers based on a particular attribute. However this particular attribute has 27 different possibilities and I want to run a query that reports back each distinct attribute with the stores numbers listed under each result. I have gotten this to work but it is returning each distinct attribute onto a seperate result tab. This is the basic SQL that I am starting with (I am working in Navicat SQL Server desktop)
SELECT MailerUId As AE FROM "Wawa 012113" WHERE CAT LIKE 'AE'
I thought I did explain. Copied from initial question as to what I want as it appears you missed it... I want to run a query that reports back each distinct attribute with the stores numbers listed under each result This is what is being output when I write SELECT MailerUId As AE FROM "Wawa 012113" WHERE CAT LIKE 'AE'
SELECT MailerUId As BE FROM "Wawa 012113" WHERE CAT LIKE 'BE'
Result 1 (first tab) AE 6 Result 2 (second tab) BE 486
This is what I would like to return all on one result tab AE BE 6 486
Select multiple attributes
Posted - 01/31/2013 : 11:22:14
