question

lazyme avatar image
lazyme asked

Help with SQL update query

Hi, I have 2 sql student tables Student1 and Student2
                    
Student1
                    
Student ID   Name    Test taken     Test Date      Test Result
                    
1            Sam     TB             05/23/2010     Pending
                    
1            Sam     MMR            06/20/2010     Pending
                    
2            Tom     MMR            07/14/2010     Pending
                    

                    
Student2
                    
Student ID   Name    Test taken     Test Date      Test Result
                    
1            Sam     TB             05/23/2010     Pass
                    
2            Tom     MMR            07/14/2010     Pass
                    
As you can see, both the tables have no primary key and some entries in Student1 are updated in Student2 I want to write an sql query that will update all the matching Student1 entries from Student1. For the entries to match, the Student ID, Name, Test taken and Test Date fields should match. Then for these matching entries we check if the Test Result has been updated and update the same in the table Student1. So, our Student1 table after executing the query should be
                    
Student1
                    
Student ID   Name    Test taken     Test Date      Test Result
                    
1            Sam     TB             05/23/2010     Pass
                    
1            Sam     MMR            06/20/2010     Pending
                    
2            Tom     MMR            07/14/2010     Pass
                    
Someone please help me write this query.
sqlqueryupdate
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.