I have two tables. A lookup table that has a PK and various columns. Looks something like this:
PK OperatorID, OperatorName, BadgeIDMy
main table saves the BadgeID value from the tblOperator instead of the PK OperatorID. So when I do an INNER JOIN between tblMain and tblOperator, I get duplicate records returned.
Is there a way to not get the duplicate records, other than to go back to myMain Table and save the FK OperatorID instead of the value of BadgeID.