im trying to move/copy a colomn("bates") from table two, and place/replace/insert it in table 1("bates" colomn, same table name but different values)(or, just insert it to table 1, without replacing anything)...i been trying join, inner, left, outer, etc, nothing works, i get it show in table1...