Search results

Going off of Pat Harman's recommendation for using a more complex where clause, I found a solution by making a Cartesian join for all possible Branch and CWDepartments and set where conditions to only show the combinations that are present in the Employees table. I then made a separate query for...

I'm having an issue with setting up a union query where I receive an error saying "Syntax error in query expression ''." I'm able to run all combinations of the union with just two of the queries, but when I add the third I run into this issue. I also have other queries in this database that...