I have two tables that I need to join based on the date differences. Table a looks like this:
```
Date Partner Revenue
12/01/20 Cosmo 10
12/01/20 Esquire 5
```
Table b looks like this:
```
Date Partner Revenue
12/01/20 Cosmo 10
12/01/20 Esquire 5
12/02/20 Cosmo 20
12/02/20 Esquire 25
```
I need to grab everything from table **b**, which is later than the last (max) date in table **a**.
My desired output of table c is:
```
Date Partner Revenue
12/01/20 Cosmo 10
12/01/20 Esquire 5
12/02/20 Cosmo 20
12/02/20 Esquire 25
```
This is what I have tried
```
select a.`Date`,
a.`Partner`,
a.`Revenue`
from a
inner join b
where b.`Date` > (select(max(`Date`))) from a
```
Error message:
> The database reported a syntax error: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near 'from a' at line 6