Re: Two columns query from a single column table?

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 on the left, and from row to the end on the right. TIA Mensaje citado por Scott Klarenbach <[EMAIL PROTECTED]>: > SELEC

Two columns query from a single column table?

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 | |-