Hi, I have 2 tables both have a field that is Number(11) and I am trying to devise a list of rows in table 2 that do not have a matching field in table 1.
Table 1 Table 2
Field_x field_y
I need all field_y's that do not appear in field_x
if field_x has 3 values 221,223,222 and field_y has the fields 221,222,224 then i need my list to show 224. I realize that this may be easy but I need help on it. Thanks in advance for any assistance
Table 1 Table 2
Field_x field_y
I need all field_y's that do not appear in field_x
if field_x has 3 values 221,223,222 and field_y has the fields 221,222,224 then i need my list to show 224. I realize that this may be easy but I need help on it. Thanks in advance for any assistance