How to get multiple values for same ID in row by row for a join multiple table using single ID. Here is sample,
DB Postgresql.
Table 1 :emp_tbl
ID dep_id name dept.
1 10001 name1 xxxx
2 10001 name2 yyyy
3 10002 name3 zzzz
4 10003 name4 zzzz
5 10004 name5 ssss
Table 2: sal_tbl
ID emp_id sal.
1 10001 10000
2 10002 20000
3 10003 30000
4 10004 40000
Need to join two tables using query, and get below response
Response:
ID emp_id name dept. sal.
1 10001 name1 xxxx 10000
name2 yyyy
2 10002 name3 zzzz 20000
3 10003 name4 zzzz 30000
4 10004 name5 ssss 40000