A tricky query problem

[quiero mas]

what i am trying to do is
1. let a user decide which language they want
2. pull the apropriate information fom a few different tables

project background: a multilingual hospital guide for non Japanese residents
here in Sapporo, Japan.
so i have each hospital and its information and then the languages doctors can
speak at each hospital.
What i want the user to be able to do is choose which language they want and
the query will pull out the hospitals which match this query .
at the moment i have different tables for each language and a -1 or 0 next to
each listed hospital depending on whether they have a doctor that speaks the
language.

I hope you all know what i mean. I can get a simple query working but not for
the advanced version

so far i have

select hospital_name
from English_Language, Spanish_Language
where (here im stuck)

[Dan Bracuk]

My approach would be to have 3 relevent tables, languages, hospitals and
languages_hospitals. The last one would have a many to many relationship with
the other two.

Then the query would no longer be tricky.

Originally posted by: quiero mas
what i am trying to do is
1. let a user decide which language they want
2. pull the apropriate information fom a few different tables

project background: a multilingual hospital guide for non Japanese residents
here in Sapporo, Japan.
so i have each hospital and its information and then the languages doctors can
speak at each hospital.
What i want the user to be able to do is choose which language they want and
the query will pull out the hospitals which match this query .
at the moment i have different tables for each language and a -1 or 0 next to
each listed hospital depending on whether they have a doctor that speaks the
language.

I hope you all know what i mean. I can get a simple query working but not for
the advanced version

so far i have

select hospital_name
from English_Language, Spanish_Language
where (here im stuck)

[quiero mas]

As always Dan... thanks for the help
i ll give it a try

Ta