Can someone please help me out with a query? In Microsoft SQL Server, I have the following query, which executes fine:

```
SELECT * FROM ControlPoint
INNER JOIN Project ON ControlPoint.ProjectID = Project.ProjectID
INNER JOIN Site ON Site.SiteID = Project.SiteID
WHERE Project.ProjectName LIKE '%Flood%'

```

My problem is, when I try to execute this on Microsoft Access, it gives me some kind of syntax error. It's been forever since I've used Access, but if I remember right, I think the joins need to be in parenthesis or something. Any help would be useful!
['https://Stackoverflow.com/questions/957172', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/98094/']
You will need some parentheses in addition to changing the wild cards:

```
SELECT * FROM (ControlPoint
INNER JOIN Project ON ControlPoint.ProjectID = Project.ProjectID)
INNER JOIN Site ON Site.SiteID = Project.SiteID
WHERE Project.ProjectName LIKE '*Flood*'

```

Note that the asterisk is used in the Access query window and with DAO, percent is used with ADO.
Use this sintax in access never fails

(this is an example)

select \* from customer, adress
where customer.id = adress.customerId