I have a query that is pulling information from two tables, can I pull from
others as well?
SELECT
r.resumeID,r.userID,r.skills,r.dateAdded,u.firstName,u.lastName,u.city,
u.province FROM resumes r,resumeHolders u WHERE r.userID=u.userID AND
u.city='Kitchener'
I want to be able to pull the categoryID and the experienceID from the
resumes table and get the corresponding description from the categories and
experience tables, is this possible with something like this:
SELECT r.resumeID,r.userID,r.skills,r.dateAdded, r.categoryid,
r.experienceid,u.firstName,u.lastName,u.city, u.province, c.descrip,
e.descrip FROM resumes r,resumeHolders u, categories c, experience e WHERE
r.userID=u.userID AND r.categoryid=c.categoryid AND
r.experienceid=e.experienceid AND u.city='Kitchener'
Its getting to be a big select, not sure if it will work :)
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
