Posted by cahyadi on 03/09/06 03:31

thanks for your information, but if i want increment 7 i try syntax :
SELECT A.autobaris, B.autobaris AS Expr1, A.nilai + B.nilai AS tot
FROM ac A LEFT OUTER JOIN
ac B ON A.autobaris + 4 = B.autobaris
and the result :
autobaris exp1 tot
1 4 9
5 8 22
9 null null
but i want the result :
autobaris exp1 tot
1 4 20
5 8 44
9 10 18
please help thanks

[Back to original message]