Mohamed, that's the thing. I need them to have Insurance X. An 'Or' would return patients that have Insurance Z only, for example, wouldn't it?

For example.

Bill...

Wayne...I tried the Alias table angle...still couldn't get it to work

select

HR.MRN MRN

,HR.FIRST_NAME FirstName

...

I'm not the best at explaining...so here goes nothing...

Basically I'm pulling data on Patients that has Insurance X. But, patients that have that insurance will have other insurances as...

The Patient Information is in the HR Table and the Insurance is coming from INSCOMP

Here is the Query

select

[cprsql].dbo.HR.MRN MRN

,[cprsql].dbo.HR.[FIRST_NAME] FirstName

,[cprsql].dbo.HR.[LAST_NAME] LastName

...

Thanks! So, are you saying something like this?

Select column A, column B, max (case when) as Drug, max (case when) as Reason

From.....

Group by column A, column B