using left outer join

Before

select OrderID,ProductID

from [Order Details] od 

After

select OrderID,
p.CategoryID

from [Order Details] od 
left outer join Products p on p.ProductID = od.ProductID 

---

Help us improve, Edit this page on GitHub
or email us at info@fireflymigration.com