The problem is that you are using SELECT to return rows from two tables: and that means that SQL tries it's best to return a separate row for each combination.
For example, if you have two rows in TableA and three rows in TableB then a simple query:
SELECT A.ID, A.[Desc], B.ID, B.[User]
FROM TableA A, TableB B
Will give you six rows:
ID Desc ID User
1 D1 1 U1
1 D1 2 U2
1 D1 3 U3
2 D2 1 U1
2 D2 2 U2
2 D2 3 U3
Two for each row in TableA and three for each row in TableB
If you want to return just the rows in TabelA with some informationation from related rows in TableB, then you need to use a JOIN on the appropriate columns:
SELECT A.ID, A.[Desc], B.[User]
FROM TableA A
JOIN TableB ON a.ID = b.TableAID
Since we don't have access to your data, and have no idea what the relationship(s) might be, you will have to work out the exact JOIN format for yourself!