1 Reply Latest reply on Mar 1, 2018 1:47 AM by Tushar More

    Custom SQL Query Inner Join

    Andy UK

      Hi

       

      I'm using the Custom SQL query to create a prod table.

       

      I've used SELECT and then the MID function to create a new column for "country" (DE, UK, US etc)

       

      I've a table called "Country_Region" which contains the country codes (DE, UK, US etc) and the Region.

       

      I want Region in my results, how do I write this in the SQL?

       

      Many thanks

       

      Andy