Re: Simple JOIN?

[Peter Brawley]

You could write ...

update xyz
join abc using(cust_id)
set xyz.cust_id=abc.cust_id
where abc.cust_id is not null;

... but it'd be entirely redundant and therefore bad practice, you need just one copy of the address unless you are tracking date-defined addresses, which the schema you show doesn't do.

So if you wish to report customer addresses for orders, just write ...

select xyz.cust_id, xyz.product, xyz.price, abc.address
from xyz
join abc using(cust_id)
order by cust_id;



Edited 1 time(s). Last edit at 12/22/2021 11:48PM by Peter Brawley.