title: Maintenance Table, presentation of Data using record details as column headers and extracting only most recent maintenance
body: <p>I've tried to find a solution to this issue I'm facing but I'm not sure how to advance.
  To be honest I am not too sure how to even phrase my question, but please bear with me.</p>
  
  <p>I have a table which is essentially a table which is written into every time an update on a customer record is made, its an odd table but it has been in use for quite awhile and contains over a thousand records. The customer records are not often updated due to the nature of the business.</p>
  
  <p>Now since the table is updated every time an update to the customer record is performed, it is such that each record in this table only contains 4 parts, the customerID, the field which was updated, the details which were updated into the said field, and the date on which the update was performed.
  Sample:</p>
  
  <pre><code>--------------------------------------------------------------------
  | CUSTID            UPDFIELD    UPDDETAILS              UPDDATE    | 
  |------------------------------------------------------------------|
  | 444001001201111   custName    Smith Worlogh           2014-02-01 |
  | 444001001201111   discRate    5%                      2014-05-01 |
  | 444001001201111   custName    Smith Warlogh           2014-05-07 |
  | 444001001201111   custEmail   smithkiw67@yahoo.com    2014-05-10 |
  | 444001001201112   custName    Pauline HG Stone        2014-02-01 |
  | 444001001201112   discRate    5%                      2014-05-07 |
  | 444001001201112   custEmail   sama8kitty@live.co.uk   2014-05-11 |
  | 444001001201112   discRate    8%                      2014-05-15 |
  | 444001001201113   custName    Jayden Rothschild       2014-05-01 |
  | 444001001201113   discRate    8%                      2014-05-07 |
  | 444001001201113   custEmail   mr.bombastic@gmail.com  2014-05-11 |
  --------------------------------------------------------------------
  </code></pre>
  
  <p>From that table I want to present the data in a way where all the details are shown for each customerID and in the last column a date, corresponding to the last update for that particular record is shown. Using the Sample above, I want to present the data like this</p>
  
  <pre><code>-------------------------------------------------------------------------------------
  | CUSTID           CUSTOMERNAME       CUSTOMEREMAIL           DISCRATE  LASTUPDATED |
  |-----------------------------------------------------------------------------------|
  | 444001001201111  Smith Warlogh      smithkiw67@yahoo.com    5%        2014-05-10  |
  | 444001001201112  Pauline HG Stone   sama8kitty@live.co.uk   8%        2014-05-15  |
  | 444001001201113  Jayden Rothschild  mr.bombastic@gmail.com  8%        2014-05-11  |
  -------------------------------------------------------------------------------------
  </code></pre>
  
  <p>I believe my first step should be to find the most recent update for each particular customer which I managed to do with this simple SELECT statement</p>
  
  <pre><code>SELECT MAX(UpdDate) AS LatestUpd,CustID
  FROM trackChangeA
  GROUP BY CustID;
  </code></pre>
  
  <p>After that I thought I could use the above results in a subquery to extract the latest updates for each field for each respective customer but instead everything is returned.</p>
  
  <p>I am unsure how to proceed from here. Again I did try looking through the SQL section for something similar but all I managed to find was a way to use DISTINCT but trying that didn't change the results much.</p>
  
  <p>I've been trying to try solutions on the sample table in SQL fiddle but so far to no success. Here's the link if it helps: <a href="http://sqlfiddle.com/#!6/19fe5/15/1" rel="nofollow">SQL Fiddle</a></p>