Union and if with value present in other table Power BI

I have 3 tables. The first one is a product table.

The second one is also a product table but some product are also present in the first one.

And finally, I have a sales table.

Here is my demand. I would like to union the two product tables in a new one and if one product is in 'Sales', then add a new column with the name of the client. This kind of result

I want to do it in Power BI, but I can't find a solution to do it in Query Editor.

Any idea ?

Thanks.