Outer Join showing duplicates

[saanah2019]

Hi guys. I have 2 large data tables and I want to combine them based on a unique field. The only reason I want to combine them is because I need to do a lot of conditional formulas and so it seems easier to combine them. I use all the joins but none of them show the data correctly. the closest was the outer join but it only showed correct data for one table while duobling everything from the other table. Is ther anything I can do to either fix the outer join or create a new table with the required fields from the 2 tables.

[Anonymous]

Without seeing some sort of example, have you tried the Full Outer Join option?