Formatting in same columns when selecting from two tables.

[Lucas.CTR.Heuman@xxxxxxx]

I have a table in my database with 4 fields, Because it is already 
implemented in the application I am modifying I cannot change the table. 
Here is what I have
DATA1STAMP type DATE  , DATA1DATA type INTEGER, DATA2STAMP type DATE, 
DATA2DATA type INTEGER in my DATATABLE.

I now need to select this and format the results as
DATA , DATASTAMP in two columns when selecting from this table to report. 
Can I join on the same table in a way that the data can format correctly?


My plan is to try and use a Sub select kinda like SELECT * from (SELECT 
DATA1STAMP as DATASTAMP,  DATA1DATA as DATA from DATATABLE) and (SELECT 
DATA2STAMP as DATASTAMP,  DATA2DATA as DATA from DATATABLE) WHERE 
DATASTAMP < NOW();

I'm not sure if this can be done.. any ideas?