Select records with multiple conditions

[France]

Hi,
I am working with a ticket database that stores the problem reported. Each ticket can have multiple problems reported. I am trying to filter out certain tickets.

Basically, I want to be able to only have those tickets that have a problem reported of No Loss of Service and See Remarks. Then i want to concatenate these problems into one field so that I have one line per ticket. Is there a way to do that.

Here is an example of my table:

TKT_CRTE_DATE TKT_NUM TKT_SK PROB_RPT
1/1/2010 1:06:00 PM 266 10567134 Customer checked breaker
1/1/2010 1:06:00 PM 266 10567134 See Remarks
1/1/2010 2:56:00 PM 352 10567220 No Loss of Service
1/1/2010 3:23:00 PM 475 10567344 Confirmed Out Of Service
1/2/2010 6:31:00 AM 46 10567811 See Remarks
1/2/2010 8:29:00 AM 99 10567864 No Loss of Service
1/3/2010 12:06:00 AM 2 10568376 Fire/Police
1/3/2010 12:06:00 AM 2 10568376 No Loss of Service
1/3/2010 12:06:00 AM 2 10568376 See Comments
1/3/2010 9:09:00 PM 547 10568921 See Remarks
1/4/2010 10:38:00 AM 455 10569418 No Loss of Service
1/4/2010 10:38:00 AM 455 10569418 See Remarks

[Frinavale]

Write a SQL query that Selects everything from the table that has a title of Loss of Service Or See Remarks...

Something like:

SELECT * FROM MyTicketTable 
WHERE PROB_RPT = 'Loss of Service' OR PROB_RPT = 'See Remarks'

This will return you all records that have a Problem Reported as Loss of Service or See Remarks.

From there you should loop through the records and do your concatenation logic.

-Frinny