This will do it:
SELECT FirstName, LastName
FROM RealtorInfo
WHERE RealtorID IN (SELECT RealtorID FROM Homes WHERE HomeID IN(#homelist#))
Chris
----------------------------------------------
Original Message
From: ""<[EMAIL PROTECTED] (paul smith)>
Subject: Re: SQL Question
Date: Tue, 10 Oct 2000 10:06:22 -0700
><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.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
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.
