I am creating 2 local views with the following characteristics:

Table A has cFileno
Table B has cFileno, cName, cGroup where cGroup can either be "1" or "2"

View 1:
For each A.cfileno there is at least one or more B.cfileno from cGroup "1".
With this I create LocalView1

View 2:
For each A.cfileno there is not always a B.cfileno from cGroup "2"

I need a second local view where all A.cfileno are present including the ones that do not have a B.cfileno from cGroup "2". I can create that view and I obtain B.cfileno = .NULL. for those that are not equal to A.cfileno.

Now instead of the null for those records I want to substitute a fixed (same) value to all of them. (The value is a common cFileno from Table B in cGroup 2) How can I do that?

Thanks in advance