select *
	from g02
	join c01 c using(gnum)
	join s01 s on (c.gnum, c.cnum) = (s.gnum, s.cnum)
	order by s.gnum, s.cnum, snum
;