Here is my query
UPDATE tracks
SET People_id_Reference = (SELECT People_id
FROM People
RIGHT JOIN top100
ON
People_name=top100.artist LIMIT 1)
WHERE People_id_Reference IS NULL;
But that query inserts same people_id value into all rows of People_id_reference Can some on help me with this. Thanks in advance