Hi, >>>>>>>>>>>> Aneez Backer wrote (2007-11-21 20:05:01): > Thanks Bernt. > > That helped
Just a small question: Is there some special (e.g. performance) requirements that force you to maintain the data in TABLEB? Since SELECT TAGCOUNT FROM TABLEB WHERE ID=xxx; should give the same result as SELECT COUNT(TAG_ID) FROM TABLEA WHERE TAG_ID=xxx; you could perhaps do without the triggers and TABLEB? -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Derby/Java DB Sun Microsystems, Trondheim, Norway
pgpwTBE7Dcjp2.pgp
Description: PGP signature
