>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.


Hi,
I was born and studied up to 3rd in maharastra so can pick up a bit of marathi, and later on lived in my native place where i am a practising Dental Surgeon. I live near Jog Falls (abt 70kms from the place i live)....

"Me bare aahe"

It is as though creating a temp table on the server through SPT with create Table ##tablename 2 ## means temptable for the user and will go out of scope when the connection ends or the table is specifically droped.

then u can insert records into the temp table through 1)insert command or 2) by making the cursor updatable , later u can use this for the orignal join.....

suhashegde