Thank you very much. It is working as I expected.

But If have lot of records, for example in my data-set I have 500 thousand records. The query is taking very...

Hi,

Thanks for reply.

But I want results set which is reached my threshold value. I don't want all records in the table. But I want to display records when...

I am sorry for that. Actually there is common column is there in two tables. Please check below

Table1:

PID ID1 ID2 ID3 ID4 ID5 ID6

1 NULL NULL NULL NULL NULL NULL

2...