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

    Custom SQL Query Inner Join

    Andy UK



      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