November 20th, 2012, 08:36 PM
Join Date: Nov 2012
Time spent in forums: 1 h 21 m 34 sec
Reputation Power: 0
I'm have 2 tables and want to group by class, but it's not working...help please
select cl.class, c.customer_ID, cl.affiliate
from class cl, customer c
where c.customer_ID = cl.customer_ID
group by cl.class (not working)
Each class has a group of customers associated with it....
I want to return all the t.affiliate info for each of the customers associated with a class. So, I'd like to see:
Last edited by RedGinger : November 21st, 2012 at 06:22 AM.
Reason: made edits to correct sql