I have these 2 tables:

```
Table A

Country    State
-----------------
 US         OH
 US         FL
 US         WA

Table B

State    LastVisitDate   City
----------------------------------
 OH        15/10/2019    Bedford
 FL        10/12/2019    Bell
 WA        20/09/2019    Perth

```

Table A can be linked with table B by field "State".

What would be the query to get the latest (last visit date) in country=US, doesn't matter which state, e.g.:

US,10-12-2019,FL,Bell
---------------------

I tried inner join but couldn't make it work.