let me make myself more clear

eg i have a local table and would like to fetch the results from another table on the sql server using one of the fields as the parameter.

suhas