SQL Statement Error - Joins

[boilermaker1997]

I'm trying to join several tables in an access query. One of the fields I'm joining on is formatted as a number in one table and text in another, so I'm using the Val function to make the data types match. That part of the statement work (first 4 lines shown below). I'm trying to add 2 additional joins, but I'm getting a syntax error when I try to run the query. I'm pretty inexperienced at Access so I'm not able to determine what is wrong with the syntax. Any advice is appreciated.



SQL Code

SELECT *
FROM
(Table1 INNER JOIN Table2
ON Table1.PPL_DEPT = Val(Table2.DEPT))
Table1 LEFT JOIN Table3 ON Table1.FUNCTION = Table3.Function) LEFT JOIN Table4 ON Table1.PPL_EMAIL = Table4.[e-Mail];

[Micron]

You have unmatched parentheses on the last line- )

[ranman256]

I don't see any Val functions here.
Only tables, no queries.

you can also try. CLNG

[Micron]

BTW - all should know that this is cross-posted in Mr.Excel forum without being declared here.

[NoellaG]

Hi,

just a remark: try to avoid SQL joins on calculated fields: the query plan can't use indexes and will be based on full table scans, so the performance will be very slow.

kind regards
NG