I have a database containing three tables: a user table with one or more attributes (e.g., normal, admin, VAR), a product table, and a junction table that connects the two. They look like the following:
Here's what I want to accomplish: I want to add a new product (either by name or id) to userprodmatrix for those users who currently have product X, where X is not the same as the new product. I have no idea how to use input...select to accomplish this (I'm very new to SQL). The correct SQL would add hundreds of rows to the userprodmatrix table.