Hello.... I am having some trouble writing a query that will pull the information I need from the database. I hope it's even possible at this point.
A little background - I have one table called 'request' and another table 'countries' The request form we have has three seperate address groups in it, so it takes three different countries per entry. The countries table contains 'country_id' and 'country_name'. The 'request' table contains 'x_country', 'y_country' and 'z_country' - these fields all reference the 'country_id' field in the 'countries' database. Now for the delimma - I need to pull out some information and dump it to a spreadsheet. That's no problem, but I need the country names instead of the country_id. So if I do - SELECT x_country, y_country, z_country FROM request WHERE ID = x - I'll get the following: ------------------- | 154 | 153 | 154 | ------------------- instead, I need this: -------------------------------------------------- | United States | United Kingdom | United States | -------------------------------------------------- I can dump one country by doing: SELECT x_country, country_name FROM request, countries WHERE x_country = country_id AND ID = x But I was hoping I would be able to do all three in one query. Any help would be *greatly* appreciated! Thanks!!! jeff --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
