would like to join 2-3 Tables for reports. However not getting any document with sufficient example. please let us know if any such document/Blog are available.
If i can get sample SQL for below, may be that will help me write more complex
Table2 - EMP
How i can get output for Name and Experience.
tried Below but not worked
select a.Name, b.Experience from emp a, dept b where a.emp_id=b.emp_id;