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.