|
|
Posted by MC on 03/09/06 11:21
Ummm, why A.autobaris + 4 if you want an increment of 7? shouldnt you
specify A.autobaris + 6?
MC
"cahyadi" <csastra99@gmail.com> wrote in message
news:1141867886.185553.79400@p10g2000cwp.googlegroups.com...
> 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
>
Navigation:
[Reply to this message]
|