queries

[sreelatha]

Hi, I am Sreelatha,

i have two tables A and B

in A i’ve a field name is accno.In B i’ve a field name is amount.

here the relation between twotables is recid.

now i want to get the sum of amounts for the account field in A table.and also in output i want to display the accno,amount,sum of amounts.

i wrote select query for this .but performance was very slow.So,please help me is there any alternative process to fulfill the requiremnt,

Thanks inadvnce

Sreelatha

[MartinDrab]

SQL query is definitely the right technology for this type of tasks. If you show your query, we may help you to optimize it. And if it’s designed correctly and performance is still bad, it’s time to look at the query execution plan to see what’s wrong.