here is a common scenario:
insert into table A
select xx, xx, xx
from table B -- where B has the rows we want to insert, but need to join to table C to get some more info
inner join table C
the problem is, if there is any missing data in table C, we might lose data. because of the missing data. but using left join will also cause issues for possible NULLs etc.
is there a good coding practice that will do the insertion and check for possible issues, for example, break and raise error if i find missing data becuase of the joins?
View Complete Post