I have 2 tables containing fields of :
Table 1 :
Employee ID Company
001 AAA
002 BBB
Table 2 :
Employee ID Period Basic Amount
001 199610 1000
002 199610 2000
001 199611 1200
002 199611 500
How can I try to create a cursor using SQL with end result of
Company 199610 199611
AAA 1000 1200
BBB 2000 500
.......
I have try the following :
SELECT table1.company, sum(table2.amount) ;
FROM table1 INNER JOIN table2 ;
ON table1.empid = table2.empid;
WHERE table2.period = '199610';
GROUP BY table1.company;
ORDER BY table1.company INTO CURSOR lc1
SELECT table1.company, sum(table2.amount) ;
FROM table1 INNER JOIN table2 ;
ON table1.empid = table2.empid;
WHERE table2.period = '199611';
GROUP BY table1.company;
ORDER BY tbale1.company INTO CURSOR lc2
SELECT * FROM lc1 INNER JOIN lc2 ON lc1.company=lc2.company INTO CURSOR lc3
PROBLEM is the cursor now is of structure :
Company_a
Basic_a
Company_b
Basic_b
Thanks in advance.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only