Como quedaria

select O.OrderID,D.ProductID,D.quantity
from Orders O inner join OrderDetails D on O.OrderID = D.OrderID