I need to know if there is any way to join two table where cloumn1 of table1 should be matched with

Table1 := wip_accounting_classes  where Primary key := CLASS_CODE

Table2 := code_combination_id    where primary key := CODE_COMBINATION_ID

CODE_COMBINATION_ID of table2 should be compared with 8 Columns of table 1

Please find the below query which i have written

select WAC.CLASS_CODE,WAC.ORGANIZATION_ID,GCC.SEGMENT1 "LBC",GCC.END_DATE_ACTIVE "LBC END DATE",WAC.Disable_date "WAC END DATE" from apps.wip_accounting_classes WAC,

apps.GL_CODE_COMBINATIONS GCC

where 1=1

and ( GCC.code_combination_id=wac.Material_Account

                  or GCC.code_combination_id=wac.MATERIAL_VARIANCE_ACCOUNT

                  or GCC.code_combination_id=wac.MATERIAL_OVERHEAD_ACCOUNT