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.
