sql problem for my sqlcommand in VB.NET

[ssfftt]

i have this sql in my sqlcommand

UPDATE    RESULTSET              RESULT.TOTALMARKS = SUM(ATQ.MARKSGAINED)FROM         ATQ INNER JOIN                      RESULT ON ATQ.RID = RESULT.RIDWHERE     (RESULT.RID = @RID)

it gave me error, says: the designer doesnot graphically support the Optional FROM clause SQL construct.can anyone help plz?

 

[Pace]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_82n9.asp