On 23 Mar 2007 04:50:53 -0700, "Captain Paralytic"
<paul_lautman@yahoo.com> wrote:

>On 23 Mar, 10:51, Anony <y...@no.com> wrote:
>> done it!
>>
>> SELECT Hirer.Hirer_ID, Hirer.Hirer_First_Name, Hirer.Hirer_Surname,
>> Hirer.Hirer_Address, Hirer.Hirer_DOB, accounts.Account_number,
>> Account_Type.Account_Type, account_status.Account_Status,
>> Clients.Client_Name, Agents.Agents_Name, Vehicle.Vehicle_Registration,
>> hirer.Hirer_Accessed_by
>> From hirer left outer join Accounts on (hirer.hirer_ID =
>> Accounts.hirer_ID)
>> left outer join account_status on (Accounts.account_status_ID =
>> account_status.account_status_ID)
>> left outer join Account_Type on (Accounts.Account_Type_ID =
>> Account_Type.Account_Type_ID)
>> left outer join Vehicle on (Accounts.Account_ID = Vehicle.Account_ID)
>> left outer join Clients on (Accounts.Client_ID = Clients.Client_ID)
>> left outer join Agents on (Accounts.Agents_id = Agents.Agents_id)
>> join Arrangement on (Accounts.Account_ID = Arrangement.Account_ID)
>> left join Arrangement AS a1 ON
>> Arrangement.Arrangement_Entered_into_Date <
>> a1.Arrangement_Entered_into_Date
>> AND
>> Accounts.Account_ID = a1.Account_ID
>> WHERE a1.Account_ID IS NULL AND Account_Status.Account_Con_Live='1'
>> AND
>> Arrangement.Arrangement_Met='0' AND CURDATE() >
>> Arrangement.Arrangement_Expires_Date
>
>Well done!

Thanks, 4 days on that sucker!