Link to home
Start Free TrialLog in
Avatar of Ennio
Ennio

asked on

Need help with query

I want to get data from 3 table for a query, but I keep getting the data duplicated.

The problem is when I add the 3rd table(TimeSpent), because it has multiple data from the same company.

Here is my query
SELECT CompanyInformation.CompanyName, TimeSpent.WorkingDate, LoginInformation.Description
FROM (CompanyInformation INNER JOIN TimeSpent ON CompanyInformation.CompanyId = TimeSpent.CompanyId) INNER JOIN LoginInformation ON CompanyInformation.CompanyId = LoginInformation.CompanyId;

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial