Regarding Select statement?
i have a table with fields pid,epiid,episrno,serviceid,payserialno,amount,minprice.
pid,epiid,episrno,serviceid these are primary fields.
if minprice = 8000,and the patient had pay like
pid payserialno amount Minprice
A 1 1000 8000
A 2 2000 8000
A 3 4000. 8000
now i have to check the total amount with minprice.how can i get the total amount.
ie how can write the SELECT statement?