Pitanje nije sasvim jasno. Predpostavljam da ti treba duplo spajanje jedne tabele sa drugom, nesto poput
Code:
SELECT pt1.osoba, dt.tekst, pt2.osoba
FROM druga_tabela AS dt
INNER JOIN prva_tabela AS pt1
ON dt.id_osobe_1 = pt1.id
INNER JOIN prva_tabela AS pt2
ON dt.id_osobe_2 = pt2.id
"The best code is no code at all."
- Zidar (ES član)
"Biggest obstacle to learning
SQL is unlearning procedural
programming." - Joe
Celko
"Minimize code, maximize data."
- A. Neil Pappalardo