sorry for the format.

Here are the sql scripts for the question I have asked. Hope

this will make more sense to the readers.

-- Table scheme

-- [Type] field tells whether the...

Thanks OldHand,

I will check everything mentioned in your reply and let you know the result.

I appreciate your help.

i ran that query but now it return no records at all.

The problem is that the subquery -

SELECT

MAX(o.id) AS oId,

...

It does not help as there are 2000 reocrds in parent table but if use the query as corrected by i get only 1250 records.

please suggest.