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!!!!!

Its working Thanks ive got it to work now, I need one more query. I need to update the main table after making a comparison of an ID...so Insert ID in table1 if ID is not in table1 but is in table2. Thanks again for all your help

No joy Well it seems to work, but it didnt update any records. I am now just using two very simple tables. Table 1 has ID, Field1, Field2 1, Pete, Robinson 2, Sam, Walker 3, Joe, Hindes Table 2 ID, Field1, Field2 1, 2, 3, I used what you said Update table2 set field1 = 1 where...

To check When I use this: UPDATE Table1 SET Field1 = (SELECT Table2.Field1 FROM Table2 WHERE Table2.ID = Table1.ID) it gives me: operation must use and updateable query I will try your suggestion. thanks

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...