I have 2 table, table A (200 records) & table B (100 records). 2 table have the same field - partno.
I like to update "Y" into a field available in table A if partno in A =partno in B. But I do not know how to write the statement. If anyone know, pls could you share it to me. Thanks a lot