select s.gnum, s.cnum, snum, g.color, c.charge, name
	from g03 g
	join c03 c on g.num = c.gnum
	join s01 s on (c.gnum, c.num) = (s.gnum, s.cnum)
	order by s.gnum, s.cnum, snum
;