Combine two fields into one in Database view

Hi All,

I have created a view containing two tables Problem and Incident. Both tables contain a number field, so database view also shows two fields having the same label called 'Number'.

Is it possible to combine two fields into one field? 

ex: inc_number + prb_number -->> incprb_number

**I know I can get both fields combined in parent table =TASK. But running the report using TASK table is not giving me the custom fields that I have created in Incident & problem table. Hence I need to create a view for this.