[email]harpalshergill[/email] wrote:Would you care to tell us what problem you are seeing?> declare x int
> set x = (SELECT max(ixBugEvent) FROM bugevent)
> UPDATE bugevent
> SET ixAttachment = (SELECT max(ixAttachment) FROM attachment),
> ixBug = (SELECT max(ixBug) FROM bug)
> WHERE ixBugEvent = x;
> i have a problem in the given code, can anyone help me to tell what's
> wrong here?