Note, that when I omit the TOP(1) it says:
asked Dec 13, 2009 at 10:29 AM in Default
you shouldn't be using TOP (1) there. Doing so you are assuming you have only 1 single tax id in your table and your calculation will be wrong when you have more than 1 tax amount
You should multiply it before sum it up.
I Understand your requirement is from tax table you are looking for all job and there respective top tax details. eg.
if this is what your tax table should return, correct your sql in the following way.
Hope this will help you
Thanks and Regards Dinesh
answered Dec 13, 2009 at 11:37 AM