LittleNick
Technical User
Hi everyone.
I have a table tblOrder
OrderID Item Unit Match
01 Book 2
01 DVD 4
01 Games 3
02 Book 5
02 DVD 6
03 DVD 7
03 Games 8
I want to update the match field of Book and DVD to contain the unit of Games when games is in the group. as this
OrderID Item Unit Match
01 Book 2 3
01 DVD 4 3
01 Games 3
02 Book 5
02 DVD 6
03 DVD 7 8
03 Games 8
I am having problem to create the Where clause so that it grab the correct Games unit. Thanks for help.
I have a table tblOrder
OrderID Item Unit Match
01 Book 2
01 DVD 4
01 Games 3
02 Book 5
02 DVD 6
03 DVD 7
03 Games 8
I want to update the match field of Book and DVD to contain the unit of Games when games is in the group. as this
OrderID Item Unit Match
01 Book 2 3
01 DVD 4 3
01 Games 3
02 Book 5
02 DVD 6
03 DVD 7 8
03 Games 8
I am having problem to create the Where clause so that it grab the correct Games unit. Thanks for help.