SQL Merge Tables Based on Present Values [duplicate]

Question

I am trying to populate a table with the consent values for two different places based on the same ID.

So I have table A:

id    consent_value
111      Y
222      Y
333      N

and table B:

 id    consent_value
111         Y
222         N
444         N
555         N

my desired outcome table would look like this:

id      a_consent_value       b_consent_value
111          Y                     Y
222          Y                     N
333          N                    NULL
444         NULL                   N
555         NULL                   N

I have been trying to wrap my head around how to do the SQL for this, but am really struggling with creating my desired outcome table.

Could anyone point me in the right direction?

Try something like, per @DanielA.White comment, CREATE TABLE new_table(id integer, a_consent_value boolean, b_consent_value boolean) AS SELECT a.id, a.consent_value, b.consent_value FROM table_a as a full join table_b as b on a.id = b.id — user7070613
– user7070613, Commented Feb 19 at 17:01

Mureinik · Accepted Answer · 2025-02-19 17:03:01Z

1

A full outer join should do the trick:

SELECT          COALESCE(a.id, b.id) AS id,
                a.consent_value AS a_consent_value,
                b.consent_value AS b_consent_value
FROM            a
FULL OUTER JOIN b ON a.id = b.id

answered Feb 19 at 17:03

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kshitij Feb 19 at 17:30

you can add ORDER BY id; as well to match the same output

Collectives™ on Stack Overflow

SQL Merge Tables Based on Present Values [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related