Re: Help with JOIN query

From: Date: Thu, 06 Mar 2008 19:21:44 +0000
Subject: Re: Help with JOIN query
References: 1 2 3  Groups: php.db 
Request: Send a blank email to php-db+get-44703@lists.php.net to get a copy of this message
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

« previous php.db (#44703) next »