Multiple INNER JOIN SQL ACCESS

Question

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

User · Answer

Thanks HansUp for your answer  it is very helpful and it works   I found three patterns working in Access  yours is the best  because it works in all cases    INNER JOIN  your variant  I will call it  closed set pattern   It is possible to join more than two tables to the same table with good performance only with this pattern   SELECT C Name  cr P FirstName     cr P SurName AS ClassRepresentativ  cr2 P FirstName     cr2 P SurName AS ClassRepresentativ2nd FROM        class        INNER JOIN person AS cr         ON class C P ClassRep cr P Nr             INNER JOIN person AS cr2      ON class C P ClassRep2nd cr2 P Nr         INNER JOIN  chained-set pattern   SELECT C Name  cr P FirstName     cr P SurName AS ClassRepresentativ  cr2 P FirstName     cr2 P SurName AS ClassRepresentativ2nd FROM person AS cr INNER JOIN   class     INNER JOIN   person AS cr2      ON class C P ClassRep2nd cr2 P Nr   ON class C P ClassRep cr P Nr    CROSS JOIN with WHERE  SELECT C Name  cr P FirstName     cr P SurName AS ClassRepresentativ  cr2 P FirstName     cr2 P SurName AS ClassRepresentativ2nd FROM class  person AS cr  person AS cr2 WHERE class C P ClassRep cr P Nr AND class C P ClassRep2nd cr2 P Nr

User · Answer

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

[sql] Multiple INNER JOIN SQL ACCESS

Examples related to sql

Examples related to ms-access

Examples related to join

Examples related to inner-join