mokahola

thnx, but I didn't want it in there permenently, but I fond a way: SELECT * FROM mods UNION ALL SELECT * FROM patches ORDER BY adddate

Hi, I have two tables, one for patches and one for mods, I want to merge these into one table.  Each has the same structure, as follows: +-----------+-----------+-----------+ | name        | adddate    | views      | +-----------+-----------+-----------+ |<name>    | <date>      | <views>  | |<name>    | <date>      | <views>  | +-----------+-----------+-----------+ Now I want to combine them so that all the information is in one table, so I can order them by the adddate, and that the names of the patches and the names of the mods are in the same [name] column. The same goes for the other columns. I searched the internet and couln't find any thing about it, so maybe it isn't even possible. Thanks in advance. mokahola.