Combine 2 rows into 1 row - Sybase
<p>I have a resultset as below,</p>

<pre><code>id fname  lname
11 Tom   Jerry
11 Tom   Harry
</code></pre>

<p>Is there a way I could merge both the rows into 1 row, and lname value merged with comma seperated. Like below,</p>

<pre><code>11 Tom   Jerry,Harry
</code></pre>

<p>Cheers!!</p>