Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Replace .NULL. with value in a view
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement