4 Replies Latest reply: Jan 11, 2013 12:31 PM by jgarry RSS

    SQL to give all the descriptions of market ids present in a single row

    984233
      Hi,

      Table1: MARKET
      Columns: maket id, market name

      Table2:REGION
      Columns: Region id, Region Name, market id1, market id2, market id3, market id4...... N no. of markets.

      Now, i would like to have SQL statement that should give me the row as below

      Region Name, Market1 Name, Market2 Name, Market3 Name, Market4 name...

      Please suggest.

      Thanks
      Ramchander