TYPE OF JOIN



image
Hello, how can I join these 3 datasets so I can create a dashboard that shows me the necessary information.

Hi @Geral
you can either join them in the select statement or create 3 datasets and join them.
Looks like dmpa.asin = IT.asin and dmpa_merchant_customer = nm.merchant_customer_id
BR

1 Like

Hi @ErikG I don’t know if I’m using an incorrect join, because it doesn’t throw me any data, what I need is the sales of table 1 and that it tell me the name of the asin that is obtained from table 2



1 Like

Hi @Geral,
It’s been awhile since we last heard from you on this post, are you still encountering similar issues or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @Geral - If all your tables are coming from the same database, you can create a custom sql and run it and avoid the join from QS as well. You can test the sql beforehand from any client tool to validate the output.

Regards - Sanjeeb

1 Like