select sname,phone,feebal,feepaid from student s left outer join fees fon s.sid=f.sid;union select sname,phone,feebal from student s right outer join fees f on s.sid=f.sid;u can use this compile code