How can I join EGP_SYSTEM_ITEMS_B , EGP_ITEM_CLASSES , EGP_ITEM_CATEGORIES_TABLE ?

Summary:

I need to add item number with item class and item category in bip,

How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):