Skip to main content

Posts

Showing posts with the label JOIN

UPDATE TABLE WITH JOIN

-- CREATE TRG_STUDENT TABLE CREATE TABLE TRG_STUDENT (                 Id INT IDENTITY ( 1 , 1 ),                 Name VARCHAR ( 50 ),                 Marks INT ) -- INSERT SAMPLE DATA TO TRG_STUDENT TABLE INSERT INTO TRG_STUDENT ( Name , Marks ) VALUES ( 'RAKESH' , 90 ) INSERT INTO TRG_STUDENT ( Name , Marks ) VALUES ( 'MADHU' , 70 ) INSERT INTO TRG_STUDENT ( Name , Marks ) VALUES ( 'NANI' , 60 ) -- CREATE SRC_STUDENT TABLE CREATE TABLE SRC_STUDENT (                 Id INT IDENTITY ( 1 , 1 ),                 Marks INT ) -- INSERT SAMPLE DATA TO SRC_STUDENT T...