|
|
My bad.... I left off two table aliases.
<cfquery name="searchall" datasource="webconveyancer" dbtype="ODBC">
SELECT cd.client_id,
cd.solicitorid,
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 b ON cd.brokerid = b.brokerid
WHERE cd.solicitorid=#solicitorid#
ORDER BY cd.clientsurname
</cfquery>
Or, you can use the pre-ANSI-92 SQL syntax as follows....
<cfquery name="searchall" datasource="webconveyancer" dbtype="ODBC">
SELECT cd.client_id,
cd.solicitorid,
cd.transaction,
cd.clientsurname,
cd.clientfirstname,
cd.clientaddress1,
cw.caseworkername,
b.brokername
FROM clientdetails cd, caseworker cw, broker b
WHERE cd.solicitorid=#solicitorid#
AND cw.caseworkerid = cd.caseworkerid
AND cd.brokerid = b.brokerid
ORDER BY cd.clientsurname
</cfquery>
Phil
|
|