Well, if you want one query, use something like:
SELECT FirstName, LastName
FROM RealtorInfo
WHERE RealtorID in
(SELECT RealtorID
FROM Homes
WHERE HomeID IN (#homelist#))
-----Original Message-----
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 10, 2000 12:47 PM
To: CF-Talk
Subject: SQL Question
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.
