sqlselect = "Select lender_offices.lend_offc_name, " + ;
"lender_offices.lend_offc_identifier, "+;
"loan_mortgagor_info.loan_id "+;
"From loan_mortgagor_info, lender_offices " + ;
"Where loan_mortgagor_info.loan_id = "+sqlkey + ;
" and lender_offices.lend_id = loan_mortgagor_info.orig_lend_id " + ;
"and lender_offices.lend_offc_id = loan_mortgagor_info.orig_lend_offc_id"
= sqlexec(fics,'&sqlselect','lender_office')

I think I just messed up with the copy & past of the code.

Here is my code again