Select from two tables

Hi,

 

I think you need to use union as per your requirement without link between this two table,

 

You can try this one,

You can refer this link for database desing as per your requirement,

https://www.entityframeworktutorial.net/entity-relationships.aspx 

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

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 

hi

 

Whether Id is common field for both table or school name

 

Thanks and regards