I am doing a left join on two data sets and there are common data fields (other than the ones I'm joining on) in the two sets of data. Some of these common fields may not have the same data, though. I am wondering if when I left join data set B on data set A which of the common fields it will keep the data from, A or B?
create table edm_spg as
select a.*, b.*
from edm_spg a left join &tblout. b
on a.loan_number=b.loan_number and a.ldate=b.ldate;