Forum Discussion
Join two tables
Hi folks,
I'm having problems to join two tables.
Ex:
I've these table: Project and Reports
| Project |
| abc |
| def |
| ghi |
| jkl |
| mno |
| pqr |
| stu |
| vwx |
| yz |
| Project | Date (DD-MM-YY) | Report 01 | Report 02 |
| ghi | 01/01/2020 | Y | N |
| jkl | 01/01/2020 | Y | Y |
| mno | 01/01/2020 | Y | Y |
| pqr | 01/01/2020 | N | Y |
| abc | 08/01/2020 | Y | N |
| def | 08/01/2020 | Y | Y |
| ghi | 08/01/2020 | Y | Y |
| jkl | 08/01/2020 | N | Y |
| mno | 08/01/2020 | Y | N |
| abc | 15/01/2020 | Y | Y |
| def | 15/01/2020 | Y | Y |
| ghi | 15/01/2020 | N | Y |
| jkl | 15/01/2020 | Y | N |
| mno | 15/01/2020 | Y | Y |
| pqr | 15/01/2020 | Y | N |
| stu | 15/01/2020 | Y | Y |
| vwx | 15/01/2020 | Y | Y |
| yz | 15/01/2020 | N | Y |
And the result I need is
| Project | Date (DD-MM-YY) | Status Report 01 | Status Report 02 |
| abc | 01/01/2020 | Not Reported | Not Reported |
| def | 01/01/2020 | Not Reported | Not Reported |
| ghi | 01/01/2020 | Reported | Not Reported |
| jkl | 01/01/2020 | Reported | Reported |
| mno | 01/01/2020 | Reported | Reported |
| pqr | 01/01/2020 | Not Reported | Reported |
| stu | 01/01/2020 | Not Reported | Not Reported |
| vwx | 01/01/2020 | Not Reported | Not Reported |
| yz | 01/01/2020 | Not Reported | Not Reported |
| abc | 08/01/2020 | Reported | Not Reported |
| def | 08/01/2020 | Reported | Reported |
| ghi | 08/01/2020 | Reported | Reported |
| jkl | 08/01/2020 | Not Reported | Reported |
| mno | 08/01/2020 | Reported | Not Reported |
| pqr | 08/01/2020 | Not Reported | Not Reported |
| stu | 08/01/2020 | Not Reported | Not Reported |
| vwx | 08/01/2020 | Not Reported | Not Reported |
| yz | 08/01/2020 | Not Reported | Not Reported |
| abc | 15/01/2020 | Reported | Reported |
| def | 15/01/2020 | Reported | Reported |
| ghi | 15/01/2020 | Not Reported | Reported |
| jkl | 15/01/2020 | Reported | Not Reported |
| mno | 15/01/2020 | Reported | Reported |
| pqr | 15/01/2020 | Reported | Not Reported |
| stu | 15/01/2020 | Reported | Reported |
| vwx | 15/01/2020 | Reported | Reported |
| yz | 15/01/2020 | Not Reported | Reported |
Could anyone help me?
Tks!!!
