1select a.s# from(select s#,score from sc where c#='001') ainner join(select s#,score from sc where c#='0
