View Single Post
Go4Expert Member
26May2009,15:33  
amit_27's Avatar
Thanks pradeep answering my question. I solved the problem.

As MySQL support "For Each Row" mechanisam, we get the directly the output which want using "new" and "old" keyword.

Lke new.acct_num, old.acct_num.

Default table not required and also not available.