КА
Константин
SELECT u."Id", u."Name", t."Name"
FROM "Users" AS u
JOIN (
SELECT uc."CityId", uc."UserId", c."Name"
FROM "UserCity" AS uc
JOIN "Cities" AS c
ON uc."CityId" = c."Id"
) AS t ON u."Id" = t."UserId";
Примерно так?
FROM "Users" AS u
JOIN (
SELECT uc."CityId", uc."UserId", c."Name"
FROM "UserCity" AS uc
JOIN "Cities" AS c
ON uc."CityId" = c."Id"
) AS t ON u."Id" = t."UserId";
Примерно так?
грубо но похоже