adding rows for missing keys to facilitate joins