Search results

I need to know , how to add the value from a field in table1 to the value of a field in table2 , and give me the total. Thats it.... HELP NEEDED!!!!!

Hi everyone I need to know how I can update a field in table 1 and set it to =1 after matching an id in table 1, that should be the same as the ID in table 2. Thats it. I can't seem to get this to happen. something like: Update table1 set fieldname_5 = 1 where table1.field1 = table2.field1...