Create Table StudNameList
(
StudId int,
StudName varchar(50),
ClassId int
)
INSERT INTO StudNameList Values(101,'John',1)
INSERT INTO StudNameList Values(105,'John Wesly',1)
INSERT INTO StudNameList Values(115,'John Alferd',2)
INSERT INTO StudNameList Values(115,'Rufans',3)
INSERT INTO StudNameList Values(117,'Rufas',4)
Create Table StudCmpList
(
StudentID int NULL,
DeptName varchar(50),
ClassId int
)
INSERT INTO StudCmpList Values(NULL,'IT',1)
INSERT INTO StudCmpList Values(NULL,'SCIENCS',2)
INSERT INTO StudCmpList Values(NULL,'MATHS',1)
INSERT INTO StudCmpList Values(NULL,'SCIENCE',4)
INSERT INTO StudCmpList Values(NULL,'SSCIENCE',3)
SELECT * from StudNameList
SELECT * from StudCmpList
i need update for StudCmpList table for this StudentID which have studentid and classid matches records update need how
will do this.
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com