<CFQUERY NAME="MyQuery" ....
SELECT ID FROM OtherTable WHERE blah
</CFQUERY>
<CFQUERY
SELECT FirstName, LastName
FROM RealtorInfo
WHERE RealtorID IN (#ValueList(MyQuery.ID)#
</CFQUERY>
best, paul
At 12:47 PM 10/10/00 -0500, you wrote:
>I have a list of ID's and I want to query based on those ID's so I have
>SELECT *
>FROM Homes
>WHERE HomeID IN(#homelist#)
>
>Now here is the question I want to run a query that pull info from another
>table based on the results of that query
>I think I want to run something like this but I am not sure of the exact
>syntax.
>
>SELECT FirstName, LastName
>FROM RealtorInfo
>WHERE RealtorID ???
>
>Run a another select statement that pulls the ID's of the realtor from the
>Homes table based on the homelist?
>
>If this seems confusing let me know and I will clarify , if I can.
>
>Kevin Schmidt
>Internet Services Director
>PWB Integrated Marketing and Communications
>Office: 734.995.5000
>Mobile: 734.649.4843
>
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
