Think I need a Self Join?
===

I have a table with the following structure:

    id, Metal, AmPm, GBP, USD, EUR, Updated, TimeStamp

I have queried the data and am able to get the last 10 rows and order them how I want as follows:

    	$r = mysql_query("SELECT * FROM(SELECT id, GBP, AmPm, Updated FROM LondonFixes WHERE Metal = 'Gold' AND UPDATED < now() ORDER BY id DESC LIMIT 10) AS src ORDER BY id ASC");

This returns a table of the form:

    id, GBP, AmPm, Updated

The problem is that I need a table of the form:

    id, GBP_AM, GBP_PM, Updated

Basically, I want to join the table onto itself to get the GBP value when AmPm = 'AM' and where AmPm = "PM" if Updated is the same.

I think that this is a self Join, but I just don't understand self joins and I am not even sure that Self Joins is what I need.