able to deal with data missing in the original tables