SELECT TOP 50 "Employees"."Title", "Employees"."FirstName", "Employees"."LastName", "Employees"."EmployeeID", "Employees"."HireDate", "Employees"."ReportsTo", "Employees"."Notes", "Flags"."SmallFlag", "Employees"."Photo", "Countries"."Lat", "Countries"."Lng", "Countries"."SmallFlagDAVResourceName", "Countries"."LargeFlagDAVResourceName", "Countries"."SmallFlagDAVResourceURI", "Countries"."LargeFlagDAVResourceURI" FROM "Demo"."demo"."Flags" INNER JOIN "Demo"."demo"."Countries" ON "Demo"."demo"."Countries"."Code" = "Demo"."demo"."Flags"."CountryCode" INNER JOIN "Demo"."demo"."Employees" ON "Demo"."demo"."Employees"."CountryCode" = "Demo"."demo"."Countries"."Code" FOR XML RAW