Stephane,

You definitely seem to want a UNION statement as Frank suggests.

What is your select statement?

>Thanks but if i do this, it only gives me identical records, it seems to eliminate duplicates. , my result table should contain 670 records but it only contains 91.