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......