join

  
id
name
address

1
1
tarun
meerut

2
2
harsh
delhi

3
3
popu
goa

4
4
nitesh
gzb

5
5
ram
noida


  
id
dept_no
post

1
1
d1
hr

2
2
d2
it

3
4
d3
analyst

4
5
d4
senior analyst


  
id
name
post
dept_no

1
1
tarun
hr
d1

2
2
harsh
it
d2

3
4
nitesh
analyst
d3

4
5
ram
senior analyst
d4


  
id
name
id
post

1
1
tarun
1
hr

2
2
harsh
2
it

3
3
popu
NULL
NULL

4
4
nitesh
4
analyst

5
5
ram
5
senior analyst


  
id
name
id
post

1
1
tarun
1
hr

2
2
harsh
2
it

3
4
nitesh
4
analyst

4
5
ram
5
senior analyst