مشکلم حل شد
من برای هر یک از جداول یک دیدگاه view ساختم و از همه دیدگاه ها یک دیدگاه دیگر ساختم و مشکلم فعلا در راحترین شکل حل شده
create view stu(stu)
as select count(*) from student
create view tea(tea)
as select count(*) from teacher
create view les(les)
as select count(*) from lesson
create view cla(cla)
as select count(*) from class
create view us(us)
as select count(*) from user1
create view yea(yea)
as select count(*) from year
create view sab(sab)
as select count(*) from sabtnam
create view cou(stu,tea,sab,les,cla,us,yea)
as select stu,tea,sab,les,cla,us,yea from stu,tea,sab,les,cla,us,yea