Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello guys,
trying allways to search berofe asking and ussualy it works not now...
i am working of messy data set where regarding on origin of the data (ID field) i need to fill in one column (code) from many tables.
Here is the situation:
p.s. using subfield (description) i know how to extract code.
I want to create new table, or fill in TABLE 1 to have this data:
Tried to use left join, but data from Table 2 and Table 3 starts to "fight", first loaded - wins. Other IDs remains empty.
Any ideas?