SELECT s_punkt.punkt_id, s_punkt.name as name_p, s_punkt.raion_id as raion_id_p,
s_raion.raion_id, s_raion.name as name_r, s_raion.oblast_id as oblast_id_r,
s_oblast.oblast_id, s_oblast.name as name_o
FROM (s_punkt
LEFT JOIN s_raion ON s_punkt.raion_id = s_raion.raion_id)
LEFT JOIN s_oblast ON s_raion.oblast_id = s_oblast.oblast_id;
|