Hi Basquait

won't it show same records in both column in different sort order?

can you try somethging like

SELECT  ID AS 1d1, fullName as fullname1 from Table where Mod (id, 2)= 0

LEFT JOIN

SELECT  ID as Id2, fullName as fullname2 from Table where Mod (id,2)<> 0

provided ID is an identirty column - ineger type

.. I am not very falilier with SQL queries.