i have two Tables
A and B
data in tables as
Table A
-------
SNo Sname
1 a
2 b
3 c
Table B
--------
SNo Course
1 x
1 y
1 k
1 z
2 x
2 z
2 d
3 y
3 z
3 e
I need the output in the following format where course is x or y or z.
1 x y z
2 x z
3 y z
Need SQL Help
Who is online
Users browsing this forum: No registered users and 5 guests