In this blog post, let’s learn about the error message “4150 Primary key of table expression name must be used for join with embedded operation expression. Tables in scope: name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4150 Primary key of table expression name must be used for join with embedded operation expression. Tables in scope: name.
Reason for the Error
You performed an embedded DELETE or UPDATE and are now attempting to join the result set of whatever that operation was with the result set of another expression. You did not use the primary key of the second expression for your join. Use the primary key to prevent returning multiple rows being returned for a single deleted or updated row.
Solution
Modify the WHERE clause to use the primary key of the table expression
