how to retive value of a column of another table in store pr

Hi Could please explain more which column you want to compare and what data u want to insert in the third table

 

 

Hi Susanta,

 

 

Write a stored proc:

 

1) After entering the values in TB, you will click on button I guess. So in that click event you need to call the stored proc either by ADO.net or ORM

 

2) Simple summary how  a stored proc should be:

 

 First you need to insert the values in the Table 1

After inserting into table1, write an insert sql auery into table 2

And write select query and select column you want from table1

i want to get number of row of two table where both column match of that two table and insert into a column of another table in store procedure with rest column from from my interface

 

for example

i have 3 table classroom1[student_name,age,roll] and classroom2[student_name,age,roll] and  studentdetails[same_age_student(int),name]

Hi could you please explain more, if you want to insert values in sql server you can try like this

 

insert into table1 (c1,c2)

select t2.C1,t2.C2 from table2 t2 --this is second table