Hi Everyone,
I have 2 tables in access database.
I wanted to create a full outer join so it will show all records from both tables and I created it.
Problem statement:
Workers table has 1 row for employee A and OT table has 2 records for employee A. So when i join them using my query, it gives 2 rows for Employee A.
I am fine with that also. When I use this query output data for my analysis, Salary Limit number shows double, because in query result it is coming twice.
Is there a way entire query will remain same but Salary Limit value will be considered only once in duplicate record cases.
I have attached my access database here. Kindly suggest some solution.
Thanks in advance.
I have 2 tables in access database.
I wanted to create a full outer join so it will show all records from both tables and I created it.
Problem statement:
Workers table has 1 row for employee A and OT table has 2 records for employee A. So when i join them using my query, it gives 2 rows for Employee A.
I am fine with that also. When I use this query output data for my analysis, Salary Limit number shows double, because in query result it is coming twice.
Is there a way entire query will remain same but Salary Limit value will be considered only once in duplicate record cases.
I have attached my access database here. Kindly suggest some solution.
Thanks in advance.