Hello,

i have 2 tables.

After joining (left join) i have:

so as you can see i have a lot of nulls - and it is ok for me because in my main table for columns:

OSType

OSVersion

OSDistro

i have already values. 

So for each column i have to go and add if statement:

if [t_VolumeSelectionsSourceMatchProtCust.osdistro] = null then [OSDistro] else [t_VolumeSelectionsSourceMatchProtCust.osdistro]

- adding 4 or 5 columns is time consuming and i belive there is option to skip this or faster this somehow. 

Can anybody help?

Jacek