hi everybody ,

i am a beginner in the sql world .

I have one quarry which takes the course details and the grade details who can attend the course

Field name :Category - Course Name - grade code

Value: Learning maths 1 G2
Story Crow and Man M2
Self Study business ethics G2
Self Study business ethics M2



I wanted to group the query but grade code G2 and M2 for course business ethics will repeat
so I wanted to have them in the same column by concatenating

how can i do that?

Regards,
Naveen

Hi its pretty easy

write the query like this and c if it works

once u insert business ethice just update the table with this
update tablename set grade code='G2,M2' where course name='business ethics'

or during insert
write an if condition
if(course name='business ethics') gradecode ='G2,M2'

and then while loading use select distinct Category ,Course Name,grade code from tablename

If this does not solve your prob let me knw

---

Meghana Lohit