SELECT Customers.Name, Managers.Name FROM Customers, Managers, Orders
WHERE Orders.id IN (SELECT id FROM Orders WHERE Amount > 10000 AND Date > 01.01.2013)SELECT c.Name, m.Name
FROM Orders o
JOIN Customers c
ON c.id=o.CUSTOMER_ID
JOIN Managers m
OM m.id = c.MANAGER_ID
WHERE o.Amount>10000 and o.Date > 01.01.2013