I have two tables, i'll compare field1 and field2 into table1 with field1 and field2 into table2. So, rows which are not exist table1 to be deleted from table2. /showing following example/
F1, F2, F3, F4 field name
Table1```` Table2````````````````````` Table2
F1 F2 F3 F1 F2 F4...
jimoo
F1, F2, F3, F4 field name
Table1```` Table2````````````````````` Table2
F1 F2 F3 F1 F2 F4 F1 F2 F4
1 k I 1 k .... ..---------------1 k .... ..
2 a I-- 2 a .... ..----result-----2 a .... ..
3 c II-- 2 b .... ..---------------3 c .... ..
7 d II--...
Hello
How can I change table2?
Table1```` Table2````````````````````` Table2
--------- 1 a .... ..---------------1 a .... ..
1 a I-- 2 c .... ..----result-----2 c .... ..
2 c II-- 2 b .... ..---------------7 d .... ..
7 d II-- 7 d .... ..
--------- 2 d .... ..
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.