This discussion is archived
4 Replies Latest reply: Jan 11, 2013 10:31 AM by jgarry RSS

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

984233 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points