Here is my situation:

I have several tables of identical structure in one database. Lets name them, x, y, z tables.

Now there is one field in x, y, z that I need to combine, lets call it date.

So what I want to do is sort in descending order the combined values of x.date, y.date, z.date and to retrieve the according rows that the values belong to.

Now keep in mind that all of the rows titled date are exact same in name and structure. Is it possible for me to do what I want to do?