select a.no,a.name,b.subid,b.subname,c.score select a.no,a.name,b.subid,b.subname,c.score from a,b,c where a.no = c.no and b.subid = c.subid ;