I need help to build SQL query.

I have 2 tables table PROJECT and PRODUCT, which has this fields:

**PROJECT:**

* PROJECTCODE
* PROJECTNAME

**PRODUCT:**

* ITEMCODE
* ITEMNAME
* PROJECTCODE
* REPLACEDBYCODE

The REPLACEDBYCODE will contain other ITEMCODE (meaning, this product has been replaced by other product). REPLACEDBYCODE will have value of blank '' if the product has NOT been replaced yet.

I want to make a report for all products like this:

```
ITEMCODE | ITEMNAME | REPLACEDBYCODE | **REPLACED_ITEM_NAME** | PROJECTNAME

```