Hi! Graham Cossey wrote:
I was hoping to avoid joining everything as there can be many entries in TableB for each record in TableA. Also wouldn't your query only return one record? I need to return all records from TableA with the latest action from TableB as well.
Yes, sorry - I realised that after I sent away my first reply.. :) I have a colleague who always says that "people don't READ their mail - the just LOOK at their mail".. It's so true! I missed some of your points.
But maybe you got some ideas from my other mail, which I seem to have posted only to you directly.. Oh well, this is a tricky one anyway...
/Krister Karlström -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php