Abhinandhu K R

Abhinandhu K R

  • 2k
  • 218
  • 17.6k

Select from two tables

Aug 28 2020 1:00 AM
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..?????? 

Answers (4)