SELECT  EmplNo
    FROM  Company, Subsidiary, SubsEmpl, Employee
    WHERE  Company.Name = 'Ford'
       AND  Company.CompanyID = Subsidiary.CompanyID
       AND  Subsidiary.Location = 'Detroit'
       AND  Subsidiary.CompanyID = SubsEmpl.CompanyID
       AND  Subsidiary.NameSubs = SubsEmpl.NameSubs
       AND  SubsEmpl.Empl = Employee.EmplNo
       AND  Employee.Name = 'Pokemon';

  select  e
    from  e in Employee, c in Company, s in Subsidiary
    where  c.Name = 'Ford' and
           s in c.Subsidiaries and
           s.Office.Location = 'Detroit' and
           e in s.Employees and
           e.Name = 'Pokemon';