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..??????

Nisha Regil · Answer

You can create a stored procedure with the below statement CREATE PROCEDURE storedprocedurename AS // all sql_statement GO; Execute a Stored Procedure with the below statement EXEC storedprocedurename; To join 2 tables you will need a column which is common on both the tables. https://www.w3schools.com/sql/sql_join.asp If you want to get the data from both talbes then you should use union or union all https://www.w3schools.com/sql/sql_ref_union.asp For type contain 1 for student and 2 for teacher, you will need to write case statement https://www.w3schools.com/sql/sql_case.asp

Jignesh Kumar · Answer

Hi, I think you need to use union as per your requirement without link between this two table, You can try this one, CREATE Proc usp_GetALLRecords As Begin select Id,studentname,schoolname, 1 as Type from StudentDetails union all select Id,studentname,schoolname, 2 as Type from TeachersDetails End Go exec usp_GetALLRecords You can refer this link for database desing as per your requirement, https://www.entityframeworktutorial.net/entity-relationships.aspx

Ajay Gohil · Answer

Hi, please describe your question briefly and as per my understanding you want to join two table.so you have to use inner join.you can simply write join query in select statement refer following site for joining 2 tables: https://www.homeandlearn.co.uk/extras/databases/sql-queries-and-joins.html https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-ver15

Laxmidhar Sahoo · Answer

hi Whether Id is common field for both table or school name Thanks and regards