BIG THANKS to

Cadavre

Sudhakar Vallamsetty

with your help got the output wanted and started a new line of learning!

To anyone interested I went with the sub query method, but a massive...

thanks Cadavre,

note taken on guidelines for posting 🙂

Very new to SQL and never used the APPLY operator. So learning hard and fast, or least trying to. Only one other...

Hi,

thanks for looking, there is one student, with ID of one(1) attending two schoolIDs (3 and 2)