BiTel

mysql> select * from contract_account where cid=87;
+------+----+-----+-----+------------+
| yy   | mm | cid | sid | summa      |
+------+----+-----+-----+------------+
| 2010 |  2 |  87 |   4 | 8000.00000 |
| 2010 |  2 |  87 |   1 | 1782.23008 |
+------+----+-----+-----+------------+
2 rows in set (0.00 sec)

mysql> select * from contract_balance where cid=87;
+------+----+-----+--------+-----------+---------+--------+
| yy   | mm | cid | summa1 | summa2    | summa3  | summa4 |
+------+----+-----+--------+-----------+---------+--------+
| 2010 |  2 |  87 |   0.00 | 100000.00 | 9782.22 |   0.00 |
+------+----+-----+--------+-----------+---------+--------+
1 row in set (0.00 sec)

mysql> select * from contract_account where cid=87;
+------+----+-----+-----+------------+
| yy   | mm | cid | sid | summa      |
+------+----+-----+-----+------------+
| 2010 |  2 |  87 |   4 | 8000.00000 |
| 2010 |  2 |  87 |   1 | 2039.82354 |
+------+----+-----+-----+------------+
2 rows in set (0.00 sec)

mysql> select * from contract_balance where cid=87;
+------+----+-----+--------+-----------+----------+--------+
| yy   | mm | cid | summa1 | summa2    | summa3   | summa4 |
+------+----+-----+--------+-----------+----------+--------+
| 2010 |  2 |  87 |   0.00 | 100000.00 | 10039.83 |   0.00 |
+------+----+-----+--------+-----------+----------+--------+
1 row in set (0.00 sec)

select yy, mm, cid, sid, round(summa, 2) from contract_account where cid=87;

mysql> select yy, mm, cid, sid, summa from contract_account where cid=87;
+------+----+-----+-----+------------+
| yy   | mm | cid | sid | summa      |
+------+----+-----+-----+------------+
| 2010 |  2 |  87 |   4 | 8000.00000 |
| 2010 |  2 |  87 |   1 | 2985.89500 |
+------+----+-----+-----+------------+
2 rows in set (0.00 sec)

mysql> select yy, mm, cid, sid, round(summa, 2) from contract_account where cid=87;
+------+----+-----+-----+-----------------+
| yy   | mm | cid | sid | round(summa, 2) |
+------+----+-----+-----+-----------------+
| 2010 |  2 |  87 |   4 |         8000.00 |
| 2010 |  2 |  87 |   1 |         2985.90 |
+------+----+-----+-----+-----------------+
2 rows in set (0.00 sec)