On 21 Mar, 14:21, Anony <y...@no.com> wrote:
> Hello there, I am trying to return all accounts whos *LATEST*
> arrangement on that account was NOT met, ie Arrangement_Met=0
>
> here are the tables in question
>
> TABLE Accounts
> (
> Account_ID
> Account_Number
> ... <more fields>
>
> }
>
> TABLE Arrangement
> {
> Arrangement_ID
> Account_ID
> Arrangement_Met
> Arrangement_Date
> Arrangement_Time
> ... <more fields>
> FOREIGN KEY (Account_ID)
>
> }
>
> I can return returns all accounts who have an arrangement that is NOT
> met no
> problem *but* if the last arrangement is met, and they have older
> arrangements that
> are not met it will still return that account... what I need is some
> nifty sql that will
> only return accounts whos most recently created arrangment (ordered by
> date and
> time) has not been met, ie Arrangement.Arrangement_Met=0 for all
> accounts ...
>
> This returns all accounts who have an arrangement that has not been
> met
>
> Select * from Accounts
> left outer join Arrangement on (Accounts.Account_ID =
> Arrangement.Account_ID) WHERE Arrangement.Arrangement_Met=0
>
> what I need is some nifty sql that will only return accounts whos
> **last / most recently added** arrangment has *not* been met, ie
> Arrangement.Arrangement_Met=0,
> regardless of older arrangements! ...
>
> Any help whatso ever anyone can give me would be amazing! Thanks in
> advance for
> taking the time to look at my problem...

Search on this NG for "strawberry query". This question gets asked a
lot and the answer is always the strawberry query.