CODEWITHSUNDEEP
sqlms-access
Alex Gordon
Alex Gordon

Reputation: 60811

sql: including data from multiple columns

i have a table that looks like this:

alt text http://img405.imageshack.us/img405/3929/33732138.png

another words i would like to take data from columns stuff1, stuff2, and stuff3, and put them together

Upvotes: 0

Views: 244

Answers (2)

cdonner
cdonner

Reputation: 37668

select 
   practice, stuff1 as stuff, count(*)
from table
group by practice, stuff1
union
select 
   practice, stuff2 as stuff, count(*)
from table
group by practice, stuff2
union
select 
   practice, stuff3 as stuff, count(*)
from table
group by practice, stuff3

Upvotes: 1

Ryan Brunner
Ryan Brunner

Reputation: 14851

The UNION command should suffice for what you want to do:

SELECT practice, stuff1 FROM table
UNION ALL
SELECT practice, stuff2 FROM table
UNION ALL
SELECT practice, stuff3 FROM table
ORDER BY practice

Upvotes: 2

Related Questions