A
Agnes
Table's invinfo got a field markseqno whose default value is 0 and "not
allow null"
Now I want to put the count no in that table.
If there is no record in "invchg" table, I think It should put "zero" in
"markseqno" but not null
SQL analyzer warn me that there is null value put in that field , why ?
update invinfo set markseqno = (select count(invno) from invchg where invno
= invinfo.invno group by invno)
allow null"
Now I want to put the count no in that table.
If there is no record in "invchg" table, I think It should put "zero" in
"markseqno" but not null
SQL analyzer warn me that there is null value put in that field , why ?
update invinfo set markseqno = (select count(invno) from invchg where invno
= invinfo.invno group by invno)