Hello,
I'm hoping someone can help to get my query to run. At work I've inherited a database and now need to add a new year to the query that calculates hourly rates.
Below is the query I've updated, the line I added is highlighted red. However I get a 'Syntax error (missing operator) in...
Hello,
Hoping some one can educate me on LEFT JOINS a bit. I'm trying to add a LEFT JOIN to a UNION JOIN but when I run the query I receive the following 'Syntax error (Missing Operator) in query expression ‘t0.Project = t3.[Project Code] Left JOIN [Ref_Project Cost Centres] AS t4 on t0.[Task...
Thanks all, I have managed to resolve this now. It turned out that the download from the online database was changing the names of the headings depending on which year the report was run for
Hello
I've seen various threads on similar problems as mine but none have been able to resolve the issue.
I have 3 tables I want to append using a union query, as I don't want all the columns I'm not using the
Select * From
but instead entering the column headings I want, below is my SQL...