Hej, mam takiego sql:
SELECT
u1.id as u1_id,
u1.name as u1_name,
u2.id as u2_id,
u2.name as u2_name,
i1.url as u1_image,
i2.url as u2_image
from users as u1
inner join users as u2 on u2.connect_id = u1.id
inner join img as i1 on i1.id = u1.image
inner join img as i2 on i2.id = u2.image
i dostaje taki wynik:
u1_id u1_name u2_id u2_name u1_image u2_image
1 a 2 b https:// https://
2 b 1 a https:// https://
uzytkownik 1 w wartosci connect_id ma id uzytkownika 2 i na zmiane.
jak to ogarnac zeby w takiej sytuacji pokazal sie jeden wynik a nie dwa?