Hi,

I need do the follow:

Table 1.
Field 1. Varchar (6)
Field 2. Varchar (6)

The data in this table are for example

Field 1                 Field 2
 A                           TT
 A                           YY
 A                           RR
 B                           FF
 B                           KK

I need to obtain a result in the following form:

A      TTYYRR
B      FFKK

How can i do this? 

Thanks for any help!

Javier


Javier Diaz
IT Developer



*** This message has been scanned for all known viruses by MessageLabs. This message 
is intended for the stated recipients only and may be confidential. Opinions expressed 
in this email do not necessarily reflect the opinions of Globepost Travel or 
Travelselect.com. If you feel you received this email in error and would not like 
receive any further emails from travelselect.com, please reply to 
[EMAIL PROTECTED] ***

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to