novice82

Hi, Thanks a lot for the code.. its very neatly gets rid of my zero divisor problem. I have one question though: Like you pointed out there is no 1:1 relationship. I should've mentioned it earlier in my post. For all account numbers in temp2 ( which has lesser records than temp1 ( the master record )), i want to calculate the balance differences in temp2 and temp1 and output to a new table.

Hi, I'm a novice to sql scripting. Am trying to figure out a design problem, involving some arithmatic computation. I have two tables temp1 and temp2 with two feilds account no., ( Common in both tables ) balance ( float data type ). 1. I want to compare the balance feilds in temp1 and temp2. print out the no. of accounts and percentage of match and mismatch. 2. output the a/c nos. whose balances dont match into a seperate table.. another question, that I have is, how does sql handle the computation, if a value in a particular field is divided by 0 ? any help, will get me started. thanks