Hi Vinu,

the excel sheet has both the data output and the expected result from what I am trying to achieve. There are 2 sheets on the excel document. Is this what you needed or I am misunderstanding you?

David to answer you:

1. CaseID has different data type in the two tables, presume this is a typo!

Case ID will vary, if you see 2 caseID's that are the same on the second sheet (what I need tab), its because the user ID is different, for this reason I cant't use a distinct on the comments, as this will give me just the single comment and miss out on the users.

2. The query has no ORDER BY. The TOP 50 you slelect could be any 50 rows, is this correct?

Yes this is correct.

p.s. Also noticed your WHERE clause is is ignoring comments containing the text 'null', is this correct or are you really trying to ignore comments containing null, the two are not the same.

This is also right oddly enough the data has both a NULL and blank, I need these filtered out as they have no relevant data I need.