List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 2 2002 2:39am
Subject:Re: Query Help
View as plain text  
At 18:22 -0600 11/1/02, John Ragan wrote:
>how about a double left join.  pick your base
>table, and then pick your request table twice,
>with each request table left joined to the base
>table and each returning its appropriate field.
>
>maybe?
>
>look in the portals for a tool that makes the
>outlandish claim of querying any data source ever
>made.  you can use it to quickly try out little
>query tricks.  i just tried this one and it seems
>to work.  since my mysql server didn't have a
>database suitable for it, i ran it against ms sql
>and oracle and it worked.
>
>(i can't name it here because i'll get in trouble
>again.)

C'mon now.  The objections were just to plugging yer
tool without making any attempt to actually answer
the questions that were being asked.

Above, you're answering the question.  Not a problem.

>
>
>
>>  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

Thread
Query Helpjeff1 Nov
  • Re: Query HelpCory Hicks1 Nov
  • Re: Query HelpJohn Ragan2 Nov
    • Re: Query HelpPaul DuBois2 Nov