**How to write sql statement?**

```
Table_Product
+------------------+
|     Product      |
+------------------+
|      AAA         |
|      ABB         |
|      ABC         |
|      ACC         |
+------------------+

```

```
Table_Mapping

+---------------+---------------+
|  ProductGroup |  ProductName  |
+---------------+---------------+
|     A*        |    Product1   |
|     ABC       |    Product2   |
+---------------+---------------+

```

I need the following result:

```
+------------+---------------+
|  Product   |  ProductName  |
+------------+---------------+
|    AAA     |   Product1    |
|    ABB     |   Product1    |
|    ABC     |   Product2    |
|    ACC     |   Product1    |
+------------+---------------+

```

Thanks,
TOM