I've been trying to figure out how I can select someone's favorite food and copy it to another table, which contains more than just the previous table's information already. Attached is my cheap mockup of what I need to do. Im not sure how to do it for every item in the table on the left. Is there a simple way of doing this? Thanks again!
My apologies. Of course, Im using SQL for this.