>hello,
>
>I have say 7 .... 20 result tables from which i have to narrow down a list of probables which exists in most of the tables . i.e. say more 7 tables have a value in 10 tables then that value must be included in the final output.
>
>How should i do it ?
>
>TIA
>suhashegde

Hi Suhas,

Create table TestProbables (MyNumber I, TableI I)
for i=1 to N && where N is the number of tables
     append from ("table"+transform(m.i))
     replace TableID with m.i for empty(TableID)
next

select count(TableID) as Occurrences, MyNumber from TestProbables ;
           group by MyNumber having  Occurrences >= MAXNUMBER into cursor PossibleCandidates

** There could be a case with the same number in one table, what do we want to do in such case?