How to write the query to get the described output

Asked Jun 02 '22 at 17:13

Active Jun 02 '22 at 17:56

Viewed 21 times

-4

TABLE A

LOAN_ID	AMOUNT_COLLECTED	COLLECTED_BY	COLLECTION_DATE_TIME
8005072625	2420	502352	4-May-22

TABLE B

LOAN_ID	TOTAL_AMT_DUE	DEMAND_DATE_TIME
8005072625	1210	5-May-22
8005072625	1210	19-May-22

Please help to get the desired output from given example tables

OUTPUT TABLE

LOAN_ID	AMOUNT_COLLECTED	COLLECTED_BY	COLLECTION_DATE_TIME	TOTAL_AMT_DUE	DEMAND_DATE_TIME
8005072625	2420	502352	4-May-22	1210	5-May-22
8005072625	NULL	NULL	NULL	1210	19-May-22

edited Jun 02 '22 at 17:56

asked Jun 02 '22 at 17:13

Ranvir Chauhan

Please provide sample data and expected result as tables, not as images. And please show what you have tried so far to solve this. – Jonas Metzler Jun 02 '22 at 17:16
https://stackoverflow.com/help/how-to-ask read this. Don’t put additional info in the comments pls. – Koen Lostrie Jun 02 '22 at 17:25
Welcome to SO. Asking specific homework questions is fine, asking us to do your homework is not. – Andrew Jun 02 '22 at 17:29
Use `FROM tableb b LEFT OUTER JOIN tablea a ON (a.loan_id = b.loan_id)` in your query. – MT0 Jun 02 '22 at 17:34
DIDNT WORKED THAT – Ranvir Chauhan Jun 02 '22 at 17:38

0 Answers0