Cetin, Thanks for your reply.

This code i m using for MS Sql Server with Vfp,
while i m executing this code i m getting that
error no. is '1526',the column prefix 'Table1' does not match with a table name or
alias used in the query.

regards
Abdulla