Ok, was wondering if somebody could help me with a bit of mysql. A query from multiple tables returns a table with the same titles for some of the columns, is there any way to change this (i.e. friendly names, i'm sure I have done this before)? If anybody is wondering I am editing the phpbb memberlist to include just what I want and data from other mods stored in different tables. E.g. SELECT a.name, a.data, b.data FROM a, b WHERE a.name = b.name; Returns: | name | data | data | I want: | name | whatever1 | whatever2 | I have searched around a little and havn't found anything yet. Like I said, I'm sure I have done this before but I don't use databases much and can't remember how. Cheers.