Multiple INNER JOIN SQL ACCESS

inner-join, join, ms-access, sql

Solution

Access requires parentheses in the `FROM` clause for queries which include more than one join. Try it this way ...

FROM
    ((tbl_employee
    INNER JOIN tbl_netpay
    ON tbl_employee.emp_id = tbl_netpay.emp_id)
    INNER JOIN tbl_gross
    ON tbl_employee.emp_id = tbl_gross.emp_ID)
    INNER JOIN tbl_tax
    ON tbl_employee.emp_id = tbl_tax.emp_ID;

If possible, use the Access query designer to set up your joins. The designer will add parentheses as required to keep the db engine happy.

Problem

Syntax Error (missing Operator) in query expression 'tbl_employee.emp_id = tbl_netpay.emp_id INNER JOIN tbl_gross ON tbl_employee.emp_id = tbl_gross.emp_ID INNER JOIN tbl_tax ON tbl_employee.emp_id - tbl_tax.emp_ID'. ``` SELECT tbl_employee.emp_ID, tbl_employee.emp_name, tbl_gross.BasicSalary, tbl_gross.totalOT, tbl_netpay.totalGross, tbl_tax.totalLate, tbl_tax.allowance, tbl_tax.SSS, tbl_tax.PhilHealth, tbl_tax.GSIS, tbl_tax.HDMF, tbl_netpay.totalDeduc, tbl_netpay.emp_ti, tbl_netpay.emp_wt, tbl_netpay.emp_np FROM tbl_employee INNER JOIN tbl_netpay ON tbl_employee.emp_id = tbl_netpay.emp_id INNER JOIN tbl_gross ON tbl_employee.emp_id = tbl_gross.emp_ID INNER JOIN tbl_tax ON tbl_employee.emp_id = tbl_tax.emp_ID; ``` I always get the error above.

Original source