Select from two tables

Question

I have two tables

TableA and TableB

 

TableA has Id,studentname,schoolname

TableB has Id,teachername,school name

 

i need to select from theese two tables with 4 coloumns in datatable-> ID, Name,schoolname,type

 

Id must contain both tables id,

Name must contain teachename and studentname,

school name must contain schoolname from both table..

type contain 1 for student and 2 for teacher 

 

How can i make the procedure..??????