Program Error
Cancel
Suspend
Ignore
Help
SQL: Error correlating fields.




>Hi Tariq,
>
>

>SELECT codes, amount, (SELECT SUM(AB.amount) FROM table1 AB WHERE LEFT(AB.codes,LEN(AA.codes))=AA.codes) 
>  from table1 AA
>

>
>The simply query is studying in the first hours on SELECT-SQL session.
>
>
>MartinaJ
>
>>Dear Experts
>>
>>I have these codes
>>
>>

>>CREATE CURSOR table1 (codes c(7),names c(10),amount n(4))
>>INSERT INTO table1 VALUES ('1','',0)
>>INSERT INTO table1 VALUES ('11','',0)
>>INSERT INTO table1 VALUES ('1101','',0)
>>INSERT INTO table1 VALUES ('1101001','',200)
>>INSERT INTO table1 VALUES ('1101002','',600)
>>INSERT INTO table1 VALUES ('1101005','',700)
>>INSERT INTO table1 VALUES ('1102','',0)
>>INSERT INTO table1 VALUES ('1102001','',100)
>>INSERT INTO table1 VALUES ('1102003','',400)
>>INSERT INTO table1 VALUES ('12','',0)
>>INSERT INTO table1 VALUES ('1201','',0)
>>INSERT INTO table1 VALUES ('1201001','',800)
>>INSERT INTO table1 VALUES ('1201003','',300)
>>
>>

>>
>>I need result shown in image
>>
>>Please