Viewing 2 posts - 1 through 2 (of 2 total)
this will definitely update the no. of branches, it will also update those rows having no branches.
Update tab1 set NoofBranch = ( Select Count(*) from tab2 where id = tab1.id...
March 5, 2007 at 12:07 am
#693030
hi
use * after '=' notation
for eg:
Select * from Employee E, Department D
where E.DeptCode =* D.DeptCOde
August 3, 2006 at 9:40 am
#653142