Hi there! The SELECTs within the SELECT didn't work. : ( I'm looking to return from one table, half on the left side, and half on the right side. This is: from row 1 to row <n> on the left, and from row <n+1> to the end on the right.
TIA Mensaje citado por Scott Klarenbach <[EMAIL PROTECTED]>: > SELECT (SELECT id from data WHERE id=1), (SELECT id from data WHERE id=4); > > This willl return you the 2 columns in one row. > > Otherwise, if you're looking to return multiple queries into one > result set, then UNION is what you're looking for. ie (select id from > data) UNION (select id from data). > > > 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] > > ---------------------------------------------------------------- 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]
