You can avoid updating every row in one table multiple times by not creating Cartesian products, as has been suggested previously.
We don't really know how to address your specific issue as you have not provided us with any example data, or ddl, nor an expected outcome. Without these we can only take shots in the dark.
Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.
No comments:
Post a Comment