<div>
SELECT dbo.Supervisors.class, RTRIM(dbo.Teachers.teacher<wbr />) + ', ' + dbo.Supervisors.supervisor<wbr /> AS Teacher FROM dbo.Supervisors INNER JOIN dbo.Teachers ON dbo.Supervisors.class = dbo.Teachers.class
</div>


SELECT dbo.Supervisors.class, RTRIM(dbo.Teachers.teacher) + ', ' + dbo.Supervisors.supervisor AS Teacher FROM dbo.Supervisors INNER JOIN dbo.Teachers ON dbo.Supervisors.class = dbo.Teachers.class

<div>
select T.class , T.teacher + ',' + s.supervisor as teachers<br />
from supervisor S , Teachers T
</div>


select T.class , T.teacher + ',' + s.supervisor as teachers
from supervisor S , Teachers T

<div>
On both of those - &quot;ORA-01722 - invalid number&quot;. &nbsp;I am using an oracle db by the way...
</div>


On both of those - "ORA-01722 - invalid number".  I am using an oracle db by the way...

<div>
Don't know oracle, but since the error say's invalid number it probably aspected numbers in the columns. Try to replace the + with &amp;&nbsp;
</div>


Don't know oracle, but since the error say's invalid number it probably aspected numbers in the columns. Try to replace the + with & 

<div>
Thank you SjoerdvW, the || did the trick!
</div>


Thank you SjoerdvW, the || did the trick!

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I am hoping that there is some way in SQL to combine the values of 2 columns into one in the ResultSet. Can you tell me if this is can be done?<br />
<br />
Teachers<br />
<br />
teacher &nbsp; &nbsp; &nbsp; class<br />
-------------------------<br />
Mr Doyle &nbsp; &nbsp; Math<br />
<br />
Supervisors<br />
<br />
supervisor &nbsp; &nbsp; class<br />
--------------------------<wbr />-<br />
Mr Reid &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Math<br />
<br />
<br />
I want to display the following:<br />
<br />
class &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;teachers<br />
--------------------------<wbr />------<br />
Math &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mr Doyle, Mr Reid<br />
<br />
<br />
Any suggestions?
</div>
</div>


Hello

I am hoping that there is some way in SQL to combine the values of 2 columns into one in the ResultSet. Can you tell me if this is can be done?

Teachers

teacher       class
-------------------------
Mr Doyle     Math

Supervisors

supervisor     class
---------------------------
Mr Reid          Math


I want to display the following:

class              teachers
--------------------------------
Math              Mr Doyle, Mr Reid


Any suggestions?

Combining 2 columns as one ?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.