Upd — Presto Full

SELECT a.id, a.val, b.val FROM a LEFT JOIN b ON a.id = b.id UNION ALL SELECT b.id, a.val, b.val FROM b LEFT JOIN a ON a.id = b.id WHERE a.id IS NULL -- avoid duplicates of matched rows

: In some European markets, the ETA Presto All-Slicer is a "full metal" electric bread and meat cutter designed for professional-grade stability and thickness adjustment. 3. Musical & Cultural Contexts presto full

LEFT JOIN + RIGHT JOIN + deduplication.

Works only for 1:1 or simple key merging. SELECT a