there are two tables in the SQLite3 database
Table 1
A B C D
1 a ww.ok;ww.ant; anything
2 e ww.kdi; ihy
3 se ww.sdd; sld
4 sd ww.akd; sdjfaTable 2
A B C D
1 sd ww.ok 1245
2 2e3 ww.kdi 432
3 de ww.sdd 232 the goal is:
first determine whether column C of Table 1 contains the domain name of column C of Table 2. If so, append the data of column D of Table 2 to the end column of the corresponding row of Table 1 (add a new column). The final result is as follows: (note: in the actual data, the domain name contained in column C of Table 1 is uncertain, may be empty, or more than 10)
Table 1
A B C D E
1 a ww.ok;ww.ant; anything 1245
2 e ww.kdi; ihy 432
3 se ww.sdd sld 232
4 sd ww.akd sdjfa NULLSQLite3 amateur, trouble seniors to break down the solution!