xxxxxxxxxx
SELECT
a.id id_a,
a.color color_a,
b.id id_b,
b.color color_b
FROM
palette_a a
RIGHT JOIN palette_b b ON a.color = b.color;
xxxxxxxxxx
SELECT
column_list
FROM
T1
LEFT JOIN T2 ON
join_predicate;
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
SELECT
a.id id_a,
a.color color_a,
b.id id_b,
b.color color_b
FROM
palette_a a
RIGHT JOIN palette_b b ON a.color = b.color
WHERE a.id IS NULL;