You were on the right track, Ken...just got the variables mixed up,
which was my fault, really...my FK in clients was not named well
according to the PK in the family_groups table.
Anyway...it did require an inner join as you have below (yuck, I hate
joins...), because I'm joining data from two tables instead of just
pulling data from one table based on relationships...at least that's
how I understand it...
Thanks for everyone's help!
Rick
Select FG.Group_ID, FG.Group_Name,
C.Client_ID, C.Client_First_Name,
C.Client_Middle_Name, C.Client_Last_Name
From Clients C
Inner Join Family_Groups FG
On C.Client_Family_ID = FG.Group_ID
Where C.Client_Family_ID =
(Select Client_Family_ID
From Clients
Where Client_ID = '#URL.Client_ID#')
> -----Original Message-----
> From: Ken Ferguson [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 03, 2005 1:58 PM
> To: CF-Talk
> Subject: Re: Why doesn't this query return more than 1 record?
>
>
> Sorry, that last one was bad:
>
> Select c.*, fg.*
> From clients c inner join family_groups fg on
> c.client_family_id = fg.group_id
> Where c.family_group_id = (
> select family_group_id from clients where client_id = #url.client_id#
> )
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219948
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
