>My table and view all have columns labeled "pat_id", "mom_id", "hosp_id". By (inadvertently) naming my parameters with the exact same labels as the source data columns (which you wouldn't have known since I had not included that info in my original post here), the query becomes ambiguous ~

Been there, done that, or something like it. The command where I always seem to bump into that is INSERT INTO.

FWIW, this is one of the arguments for a naming convention that distinguishes variables from fields.

Tamar