SELECT id, id FROM data should work just fine.
On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]