Re: SQL Problem

Well, assuming that you always have exactly two rows in tab1 for a particular value of col1, and that you want the col2 values to be in alphabetical order, this will work:

  SELECT tab1.col1

, tab2.col3
, MIN(col2) || ' ' || MAX(col2)

    FROM tab1

, tab2

   WHERE tab1.col1 = tab2.col1
GROUP BY tab1.col1


       , tab2.col3;