Re: concatenate text content in column grouped by another column.

2001-11-26 Thread Eva Fransson
D order by ... , ... limit 0,20; Eva Fransson - Original Message - > > > Does it throw an error message or output isn't what you expected? > In any event, did you try it with "HAVING"? > > I couldn't notice anything wrong from what you have there > >

Joining table with itself

2001-11-26 Thread Eva Fransson
If you want to use your table more than once you have to declare that. select ... from T1 as FirstT1, T2 as SecondT1 where FirstT1.column...=SecondT1.column...; Eva Fransson - Before posting, please check: http

concatenate text content in column grouped by another column.

2001-11-26 Thread Eva Fransson
re ... and ... group by fkEmployeeID order by ... , ... limit 0,20; But it dosn't! Is there some other way to fix this? Eva Fransson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://