Search results

I have not been able to find a model for multiple joins, both inner and outer left, with where criteria. Here is the From clause that I am getting an error for: FROM (( Patron P INNER JOIN Patron_Address PA1 ON PA1.patron_id = P.patron_id AND PA1.address_type = '1') LEFT OUTER...

I am writing a query and attempting to use an inner join in a subquery that I am using for a column value. However, Access says the following has a syntax error. Select PATRON_GROUP.PATRON_GROUP_NAME from (PATRON_GROUP Inner Join PATRON_BARCODE on PATRON_GROUP.PATRON_GROUP_ID =...

Hello, I am a new member. I'm fairly new to Access, but have been writing SQL in various programming languages commercially for more years than I want to admit. My current role is in an academic library, and I need to use Access for data access, rather than writing a Java program or the like to...