Well, you don't necessarily need a join for this - but you'd sure be
better off using one.
I think you'd get all the data you wanted by dropping the loop and
just adding another where clause to the below query.
<CFQUERY Name="Get_Clients" Datasource="#DSN#">
Select ic.company_name,
C.Client_ID,
C.Client_First_Name,
C.Client_Middle_Name,
C.Client_Last_Name,
C.Client_Name_Suffix
from clients C, insurance_companies IC, accounts A
where C.Client_ID = A.Client_ID
and A.Company_ID = ic.company_id
order by ic.company_name, C.Client_Last_Name
</CFQUERY>
On 7/31/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> Do I need a join for this?
>
> Thanks,
>
> Rick
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248255
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
