Im trying to join just 2 tables. Im join fields that have duplicates (ie 1234X is listed 6 times) this is my join on the 1234X varchar2. I can't seem to use distinct in the select statment. Gives me errors. Also trying to get past it with the group by, but am still getting duplicate 1234X.

Any ideas?