>Couple problems...
>
>First... remove the "AS" clause from your FROM statements..
>
>From MyTable1 M1, MyTable2 M2 are both implied aliases'AS' clause doesn't required in this case but it doesn't hurt either.
>Second... SQL Passthrough to either Oracle, SQL or whatever has NO idea of the "?Thisform." parameterizing parts. So... prebuild a local var for these respective values and add into the SQL-Passthrough call where needed.Oracle or SQL wouldn't see '?' parameters because they are processed by SQLEXEC() and converted into a form that ODBC/backend can understand.
>
>Now, because of your use of "?" to parameterize in case value not entered, you probably also want to validate that the given values for respective fields exist... If not, fail before even trying the call.
>
>HTH
--sb--