I need to achieve below task:

I have 5 tables as below:

Table A:

EMP_ID EMP_CODE EMP_FLAG
1 P001 P
1 S001 P
1 E001 P
2 S001 S
3 E001 E

Table E
EMP_ID EMP_Name
1 Linda
2 Ivy
3 Rose

Table B:



P_ID P_DESC
P001 150-200
P002 201-300

Table C:
E_ID E_CODE
S001 SALES A
S002 SALES B


Table D:
E_ID E_CODE
E001 Expectation A
E002 Expectation B

So, now I would like to form a query where by the result is as below:

Name Description
Linda 150-200
Linda SALES A
Linda Expectation A
Ivy SALES A
Rose Expectation A

How do I achieve this by using a SQL statement in Access?

Pls advise......