Is it possible (if so , how) to filter out Distinct values from a Query that uses two

[gberisha]

HI,


I've got a little question regarding SSReportingServices,

I am trying to build a report using 3 different tables , say : Computer , CoWorkers, Harddrive,

In the query I took the "Computer" table 2 times , Coworkers and Harddrive (Computer 2 times because if I only use one and join it with CoWorkers and Harddrive I loose certain values that aren't on the Harddrive Table , so I am joining Computer with Coworkers and than Coworkers with Computer_1 and the latter with Harddrive)


The problem I have is that as a result I am getting Twice the values from the Computer Table Each time , and therefore needed to know , if there was a possible way for me to filter out distinct values.


Thnx in Advance

Query :

SELECT DISTINCT
Computer.Modell, Computer.Name, Computer.antivir, Computer.LastUpdate, Coworker.Login, Harddrive.Status,
Harddrive.LastOnline

FROM Computer INNER JOIN
Coworker ON Computer.CoworkerID = Coworker.ID INNER JOIN
Computer AS Computer_1 ON Coworker.ID = Computer_1.CoworkerID INNER JOIN
Harddrive ON Computer_1.ComputerID = Harddrive.ComputerID

[ck9663]

I don't think you need to double-join coworker and computer. You're not even using any column from computer_1.

That could be one of the reason why you have duplicate. If you think you're missing some rows, it could be that your JOIN is INNER, not LEFT.

Happy Coding!!!


~~ CK