Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  selecting data

Author  Topic  ed89 Starting Member 1 Post Posted - 2009-10-16 : 07:54:40 Hi all, apologies in advance for the quality of this question. I have two tables, one named acts_category and one named acts_region. I have another table named "acts" which has the fields "act_category_1", "act_category_2" and "act_category_3" and also "act_region_1", ""act_region_2"...all the way up to six. My form will search for an act category and act region, but the problem is each act can have three categories set and up to six regions, for the purpose of the search. I am having some difficulty writing the query, infact getting my head around the logic is proving a hard nut to crack. Can anyone help? Many thanks Ed