I have two queries from two different sources. let’s say an api call from a CRM system, and a local database.
I’ve formatted my output from Query1 into a table. Query1 / table includes a column called ‘ProductCode’).
Query2 comes from a local db and has product details, including product code, and let’s say ‘Product Name’. The query has been run and the output available through the explorer in the left nav.
I’m an old SQL guy so what I’m trying to do is
SELECT query2.“Product Name” FROM table1 LEFT JOIN query2 on table1.ProductCode = query2.ProductCode
I want to bring in the additional field(s) into the table as a custom field.
This must be a common use case. Is there a best practice / standard pattern for this?
Thanks v m!