Join Question?

Hello everybody

I have a table with 2 fields id, name

table:  table1
field1: id
field2: name


There are 2 records.
'903','Marketing'
'903001','Sales'

I want a query in MySql to obtain the 2 names in just
one row

So, the following answer in one row

Marketing, Sales 



regards,
Mauricio

___________________________________________________
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito 
en http://moviles.yahoo.es

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10599@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.