Noel:

I have tested all variations that I can think of and your query appears to catch all situations.

I really do appreciate the help on this one. I would have never...

Noel:

I believe that there is one problem with the query. In the example below the error with the first entry being an 'E' without a preceeding 'B' is not caught.

Also,...

Noel:

Thank you for taking my question a step further and giving me a more detailed result.

I am sorry for the poorly worded question and I thank you for your help.

Howard

Ryan:

You gave me exactly what I was trying to ask for. I am very sorry for the poor wording in my original question. You are exactly correct in that if...

Ryan:

Thank you for your response. I got your query to execute without a problem however it does not give me what I need.

If possible I would like to not...

Noel

Your example is what I should have included. I am sorry.

You are correct.

Howard

I am sorry but I did not show the Sequence_Number column in my example. If you order by Sequence_Number the rows will be returned in the proper order.

What do you...

The results should be ordered by sequence_number.

paramind

Thank you, thank you, and thank you.

Your example is exactly what I was looking for.

The Fund referred to in the query refers to funds for a non-profit community center. Fund 01...

paramind

Thank you, your solution works. Now my problem is that the total of the items returned that equal zero and do not equal zero are not the total rows in the...

Ray M

You are correct in that there are many records in the non-grouped resultset.

Any suggestions on how to correct this?

Howard

Kenneth:

Thank you for the additional information. You have been a great help to me.

Howard

Kenneth:

Thank you very much for the help.

Kenneth:

Thanks, this is the answer that I was looking for. I had forgotten about using the having clause.

If I may I would like to ask one more question concerning another...

Just for a better understanding of how things work could you modify your query below and add the clause 'where cnt > 0'

--for all rows in TableA regardless of

--matching...