[SQL statment ]update table problem

[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)

 

[Agnes]

Sorry, I should post in another Newsgroup ~~