Add Fac code to another table without duplication

[Don White]

I have a table that I want to add a field from another table.

table one has a field called grp that I want to add what fac they are from.
Table two has the Fac code. How do I add the fac code without ending up with duplicate records in the new table

example:

table one:
grp 1
grp 2
grp 3

Table two
grp 1 fac 6
grp 1 fac 6
grp 1 fac 6
grp 2 fac 7
grp 2 fac 7
grp 3 fac 8
grp 3 fac 8
grp 3 fac 8
grp 3 fac 8

I want this results in new table
grp 1 fac 6
grp 2 fac 7
grp 3 fac 8

I cannot end up with adding only the fac code for the new table that should be the same but only the field fac added. No more records.


Thanks,

Don