|
|
Wow, do you have something against writing a query where you join more than one
table? Below is just an example, but you might try combining some of your
queries into a single query so that all of your required data is in a single
record.
SELECT cd.client_id,
cd.solicitorid,
cd.lnr,
cd.transaction,
cd.clientsurname,
cd.clientfirstname,
cd.clientaddress1,
cw.caseworkername,
b.brokername
FROM clientdetails cd
INNER JOIN caseworker cw ON cw.caseworkerid = cd.caseworkerid
INNER JOIN broker ON cd.brokerid = b.brokerid
WHERE cd.solicitorid=#solicitorid#
ORDER BY cd.clientsurname
Phil
|
|