Hi Suhas

"Kashe Aahet Tumi?"

Thanks for responding to my query.

>another way is to create a temp table on the sql server , populate it with filtered records ( incase u need filtering) and use the same for a join with the second spt

I am new to SQL so I am not sure how to create a temp table on the SQL server using VFP.

By the way I am not nativly Marathi speaking but had lived in Bombay (as it was called then) for 10 years so I have a bit of a rusty Marathi.