i got two tables

> 
> table A
> 
> 
> 

```
Date | A001 | B001
-------------------
2020 |  2   |  3

```

> 
> table b
> 
> 
> 

```
ItemCode | ItemName
---------------------
   A001  |   candy
   B001  |   Apple

```

is it possible to select the number from table A and also the actual itemName from table B? 
A statment in english would be something like 

```
select * from table A and itemName from table B where TableA's columnName = TableB's ItemName;

```