Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Friday, January 5, 2018

SQL Beginner: one to many relationship, updating single row based on many rows in join table

SQLServerCentral » Latest topics
SQL Beginner: one to many relationship, updating single row based on many rows in join table
Hello,

I'm fairly new to SQL and seem to be struggling with the concept of "one to many". I'll use the north wind DB for my example.
using employee table, I want to iterate through the orders table (one to many) and if there is an order that

No comments: