ok got it solved

Ok guys thx for the info

Ok, apparently a prob with the inner join......

thx for the help guys, i really appreciate it.

select

distinct P.KPAIDS_NO,P.FirstName,P.LastName

,'Age'=

Ok, srry if i didn't make myself clear in initial posting.

What is happening with the resultset of this query is that Clients are missing from the list when i filtered...

nope didn't work........... i want it to look somtin like the following

KP   cat1       cat2    cat3  cat4

1      y           no       y       no

2      y           no      y         no

3      no          no     no        no

i already did try but got the following error, i forget to mention that the index was created on a primary key.

Cannot recreate index 'PK_Patient_Info'. The new index...

oooh srry....

i'm using SQL Express, i want to create a TSQL script that will dynamicaly generate reports example.

1.

Month                   missed appoint

january, 2007                24

feb,2007                       9

2.

Week                     missed appoint

jan-14-2007                    3

jan-21-2007                     4

etc

etc

thx again

dang.... i wish there was an update-insert of sort.

anyway thx man

if these guys here say it's a bad idea.....then i really don't think you should be doing it. Unless u have some very good reason to

thx for explaining jeff.......

ooh and abt the homework thing i totally understand what your saying....Like the saying "God help those who help themselves"

so i guess ur a SQL GOD

worked like a charm, thx guys.......but could u explain to me why use "max" and the problem as to why i was getting the initial results.

thx again fellas

Select distinct Patient_Demographics.KPAIDS_NO, Patient_Demographics.LastName,Patient_Demographics.FirstName

       ,

Case when (dbo.CDC_Clinical_Diagnosis_lookup.Clinical_Diagnosis like 'Lymphadenopathy %' or dbo.CDC_Clinical_Diagnosis_lookup.Clinical_Diagnosis = 'Lymphadenopathy' ) then 'Yes' end as 'Lymphadenopathy',

Case when (dbo.CDC_Clinical_Diagnosis_lookup.Clinical_Diagnosis like 'Candidiasis %' or dbo.CDC_Clinical_Diagnosis_lookup.Clinical_Diagnosis = 'Candidiasis') then...

TestKing materials are brainDumps..

Also this they(TestKing) are presently being sued by Microsoft for distributing exact copies of microsoft exams.

>>BrainDumps are for losers, and should not be endorsed on this site

what i basically want to do, is to create a sub-join so to speak.

I have multiple join in the from clause, but there's a table already joined i want to rejoin to...