How to create a view or maybe report combine the items from 2 tables?

I think you mean n x 2 array of data. You would use Mustache or another templating engine to convert the data array / object into HTML. This code takes a small set of data and renders it to HTML:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=342
It would be more common to start from an object rather than an array of data. The Mustache template is easier to write when working with object properties rather than array indices.