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?
