mysql - Complex update using joins and group by - Stack ...

Complex update using joins and group by ... but I think this syntax is pretty close to what you'll use on MySQL. ... SELECT d.guest_id FROM guest_data d INNER JOIN host_data h ON ...

stackoverflow.com