hello experts, is there anyone who knows how to use left join LINQ for the table A/B/C
the condition is that the “Invoice” in the A/B/C is the same that will be Y. otherwise is N
| Datatable A | |||
|---|---|---|---|
| invoice | Code | ||
| 123 | 1 | ||
| 234 | 2 | ||
| 345 | 3 | ||
| Datatable B | |||
| invoice | code | ||
| 123 | 1 | ||
| 234 | 2 | ||
| Datatable C | |||
| invoice | code | ||
| 123 | 1 | ||
| the result will be like this | |||
| Datatable D | |||
| invoice | code | resultAB | resultAC |
| 123 | 1 | Y | Y |
| 234 | 2 | Y | N |
| 345 | 3 | N | N |