Oh, sorry, I didn't look close enough at your question...never mind :-)
On Tue, 15 Mar 2005 16:02:59 -0800, Scott Klarenbach <[EMAIL PROTECTED]> wrote: > 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]
