gan, sql untuk database apaan dulu ? karena setiap database beda caranya :malus Edit: kalau pakai sql server, cobain nih: SELECT .fk_id as , FROM TableA as left join TableB on .fk_id = .id and /* */ = 'recommended' GROUP BY kalau berhasil jangan lupa cendol gan :malus:malus
