> I have a very simple query to a single table as follows: > > SELECT field1, field2 FROM tbl_table ORDER BY field1 > > Is it possible to "split" the results so field1 is displayed in one row > and > field2 in another row? > > Best regards, > Jorge Maldonado