Complex Query.... I think?

[Dannat]

I have 2 tables, the first is called tblRegister and the second is tblRequest. In tblRequest I have a column named Province. In the other table I have 14 columns named after the provinces with a value of True or False within them. I need to query this table by using the tblRequest Province Column field value to retrieve that column name in the tblRegister table with a value of True that matches the tblRequest Province Column field value. How do I do this?

[Rainlover]

You should be using One Column and create a List. 14 Different Columns is not the usual way these type of things are done.

[Dannat]

I understand that but I am working in HR and these are imported text files of employees and there is a certain way we have to handle them. The Register table is the employee information and where they are willing to work so they may choose 1 or multiple provinces and in the text file it comes up as a true or false value depending on what they chose. the Request table are jobs that are coming up and I need to finds all employees willing to work in the province of that job.

Its a huge headache but I have to work with what they give me.

[Rainlover]

Are you saying that you have no comtrol over the design of tblRegister

[Dannat]

That's right. I import a text file into teh database. I have a concept of what should look like but I just don't know how to input it correctly. Here is what I have thought of but syntax is wrong:

Select * from tblRegister
Where tblRegister.(tblRequest.province.value)=true

So I need the tblRequest.province.value to be inserted as the column name for the Register table. How can I get this to work?

[Dannat]

Does anyone know if this is possible

[orange]

I'm with Rainlover, you need to structure the tables properly. You may import text files, but you can read that text into a meaningful structure without "concocting some strange structure".

By putting the data into a normalized data structure, you are not changing the data values. You are optimizing the storage for processing in an RDBMS.

I think Rainlover and I are trying to answer this part of your post

I have a concept of what should look like but I just don't know how to input it correctly.

You really need to understand the table structure before you start "evolving queries with no real understanding of syntax."

For SELECT query syntax of more than one table, you will need to understand JOINs also.

see this for a start http://www.w3schools.com/sql/sql_join_inner.asp