Thanks so much. I appreciate it.

I will post what I have done so far later today.

Thanks again.

I am building the query dynamically in C# ( c# is not the issue here) with only the options selected by the user.

However, like I said in my previous example, if a user pre-selected "music" and...

If you take a look at my first post, I used basically the same code you proposed but it does not work. Take a look at my original post.

At registration, users select multiple Areas Of Interest and these get saved on the DB. The administrator will then want to select all users that have certain interests (lets say, music, art, etc).
...

Maybe I did not explain myself correctly.

I have an advance search page (web page) showing (among other fields) all possible Areas Of Interest.

Users will check multiple AOI (say: x,y,z)...

I gave it a try and I get OR results.

How was this query done prior SQL 2005 INTERSECT?

Thanks.

Will IN('x', 'y', 'z') be treated as 'AND' or 'OR'.

I was exploring the SQL INTERSECT statement, but I am afraid the query might take too long if lots of Areas Of Interest are pre-selected.
...

Hi all,

There is a (I assume) simple query i cannot figure out (in a best practice way).

Let's say I have three tables:

Users

AOI (Areas of Interest)

Thanks so much for the clarification! Very helpful indeed!

Thanks!!

dickersonka,

Thanks so much. It worked great!
Now, could you tell me why this would work and not the where clause that I use?
Where should I use JOIN and when should I use WHERE?

Thanks...

Hi All,

I have to do a rather simple query, but a previous design error that did not make one of the fields required (it allows nulls when it shouldn't have) makes it a bit harder.

I have a...

I tried this before posting the original question and did not work:

select sum(quantity) from (

select
CFGOpportunityType.description as Market,
opportunity.stage as Stage,...

select
CFGOpportunityType.description as Market,
opportunity.stage as Stage,
CFGOpportunityStage.description as Description,
count(*) as Quantity

from
opportunity, CFGOpportunityType,...

Hi all,

I need to run a query that performs a count(*) on a table. This gives me the subtotals for each group. Now I need to sumarize the subtotals with sum the results given by the previous...

Hi there,

I did the following test and it did not returned the expected results. Let me share it.

The statement:
select distinct prjId, Mrkt1 from markets
where Mrkt1 in ('Retail', 'Offices'...

Let me add something else that might have been misinterpreted.

Columns Mrkt1, Mrkt2, MrktN do not contain the same information. To make this clearer, let me share some real data. The following...

Hi Tesuji,

As you imagine correctly, I have no power to re-design the Markets Table. I am only trying to query the database of a system that is being used in the company that am doing the work...

Hi there,

I have a master detail set of tables with a one-to-many relationship. Let's call the tables Projects (master) and Markets (details).

I need to allow users to query the database and...