TABLE_A
CLIENT_ID	ADMISSION ID	OR_DT	OR_ID	
3422103	73497171	18AUG2017:21:31:00	70304836	
3422103	73497171	23AUG2017:11:08:00	70316257	
3422103	73497171	04SEP2017:08:57:00	70349924	
3422103	73497171	07SEP2017:15:21:00	70363724	
3422103	73497171	08SEP2017:09:32:00	70372833	
3422103	73497171	11SEP2017:14:25:00	70377797	
3422103	73497171	15SEP2017:13:25:00	70390649	
286161	77605819	01NOV2019:09:27:00	72607697	
286161	77605819	09NOV2019:15:06:00	72674062	
286161	77605819	14NOV2019:23:26:00	72689906	
286161	77605819	16NOV2019:11:20:00	72693377	
286161	77605819	21NOV2019:13:14:00	72706566	
286161	77605819	02DEC2019:16:34:00	72732202	
				
				
TABLE_B				
CLIENT_ID	ADMISSION ID	ADMISSION_DT	DISCHARGE_DT	
3422103	73497171	18AUG2017:20:53:00	18SEP2017:13:57:00	
286161	77605819	01NOV2019:07:36:00	10FEB2020:10:34:00	
				
				
WANT TABLE_C 				
CLIENT_ID	ADMISSION ID	START_DT	END_DT	OR_ID
3422103	73497171	18AUG2017:20:53:00	18AUG2017:21:31:00	70304836
3422103	73497171	23AUG2017:11:08:00	04SEP2017:08:57:00	70316257
3422103	73497171	04SEP2017:08:57:00	07SEP2017:15:21:00	70349924
3422103	73497171	07SEP2017:15:21:00	08SEP2017:09:32:00	70363724
3422103	73497171	08SEP2017:09:32:00	11SEP2017:14:25:00	70372833
3422103	73497171	11SEP2017:14:25:00	15SEP2017:13:25:00	70377797
3422103	73497171	15SEP2017:13:25:00	18SEP2017:13:57:00	70390649
286161	77605819	01NOV2019:07:36:00	01NOV2019:09:27:00	72607697
286161	77605819	09NOV2019:15:06:00	14NOV2019:23:26:00	72674062
286161	77605819	14NOV2019:23:26:00	16NOV2019:11:20:00	72689906
286161	77605819	16NOV2019:11:20:00	21NOV2019:13:14:00	72693377
286161	77605819	21NOV2019:13:14:00	02DEC2019:16:34:00	72706566
286161	77605819	02DEC2019:16:34:00	10FEB2020:10:34:00	72732202