Hi , Did not know how to do this on a database that I have in sqlite
sno | id | amount 1 | 1 | 200 2 | 1 | 300 3 | 2 | 100 4 | 2 | 100 5 | 1 | 500 how could I subtract the sno 1 id 1 and sno 2 id 1 amount . hope I was able to explain good . let me know if I need to explain further -- Regards, Vishal Kashyap. http://vishal.net.in