I have written some SQL code which does not appear to work. Any pointers will be provided
- Update Table 1 Column 1 with the value of Table 2 Column 1
- Update Table 1 Column 2 with the value of Table 3 Column 1
- Update must be based on the fact that a value in Table 2 Column 2 (e.g. 62-004) is in Table 3 Column 2 (62-004.png)
I used the following SQL statement, which does not appear to work, apparently there is an unknown column:
UPDATE t1Set t1.c1 = t2.c1, t1.c2 = t3.c1;
`Where t2.c2 in t3.c2
Any guidance will be appreciated.