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
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;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.