Hi there! I need to do this: >From this table +--------------+ |id|Data | |--|-----------| | 1|Something 1| | 2|Something 2| | 3|Something 3| | 4|Something 4| | 5|Something 5| | 6|Something 6| +--------------+
Get this query +-----------------------------+ |id|Data |id|Data | |--|-----------|--|-----------| | 1|Something 1| 4|Something 4| | 2|Something 2| 5|Something 5| | 3|Something 3| 6|Something 6| +-----------------------------+ Any idea? TIA ---------------------------------------------------------------- Servicio de Correo Unidad Central - CETI - http://www.ceti.mx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]