SELECT a.adresas
FROM adresas a
INNER JOIN adr_klient_sujungimas s
ON s.kliento_id = 1 AND a.id = s.adreso_id;


SELECT *
FROM klientas k, adresas a
WHERE k.id = 1 AND a.id = 1;

SELECT adreso_id
FROM adr_klient_sujungimas
WHERE kliento_id = 1;

SELECT *
FROM klientas
WHERE id = 1;

SELECT *
FROM adresas;

SELECT *
FROM adr_klient_sujungimas;

SELECT *
FROM klientas;

SELECT id, pavarde, vardas
FROM klientas
WHERE id = 3;

SELECT id, pavarde, vardas
FROM klientas
WHERE id = 5;