create table tab1(name varchar,class int(22),noofsubject numeric(12),rank int(10),test varchar(22),stuid int(11),accodomicyear nvarchar(22))

create table tab2(name varchar,class int(22),noofsubject numeric(12),rank int(10),test varchar(22)),stuid int(11),accodomicyear nvarchar(22))

insert into tab1 values(' ravi',2 ,5 ,' ' ,'revision-II',002244,2011)

insert into tab2 values('ravi',2 ,5 ,' 1' ,'revision',002244,2011)

expecting output:

class noofsubject rank test name

2 5 - revision-II ravi

(sub division)2 5 1 revision ravi