Display different table columns in a single database view column

[simonthomas]

I have a database view where I return a value from multiple left join tables. 

This is working correctly. In this example, the last 2 columns are from the left join.

Is it possible to return all the highlighted values in a single column like this?

The aim is to be able to reference a single column regardless of which table the data originally comes from. This will become important as the number of left joins increases.

[Runjay Patel · Accepted solution]

Hi @simonthomas ,

Oob you will not get but you can create new field and store the value in it.

Please accept the solution if it helped you.

[simonthomas]

Thanks for the confirmation.