I would like to understand the machanics of the sql derived table.
Here is an example:
Select * from Products P
(select ID, Name where country = 'UK' From shops) S
ON P.ID = S.ID
Does the derived table return every record from the Shops table and then match it to products?
Does the dervie table corrolate with products using the ID column?