🚀 go-pugleaf

aleplgr wrote:
> Hi! I have a table of patients who executed a test, each test has 10
> items and I have to generate a new column with the sum of 3 of those
> 10 items. The original table columns are this: PatientID Date Items
> Points Tester.
> Date is the date the test took place, a test is started and finished
> at the same date
> Items are the 10 items of the test, one in each row of the table
> Tester is the doctor that applied the test to the patient.
> Points is the score that the patient got in that item, that date,
> applied by that tester.
> A tester can apply the same test to the same patient the same day
> more than once.
> Two different  testers can apply the same test to the same patient
> the same date so that date one patient will have 2 scores for each
> item.
>
> I need to create a table with this columns:
> PatientID Date Tester SumPoints
> (where SumPoints is the sum of 3 known items of the test, for example
> Item1, Item2 and Item3)

If I understand your description correctly then this should be workable in a 
single SQL statement.

select PatientID, Date, Tester, Sum(Points) as SumPoints
from table
where Items in ('itemA', 'itemB', 'itemC')
group by PatientID, Date, Tester

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"If there is any principle of the Constitution that more imperatively
calls for attachment than any other, it is the principle of free
thought � not free thought for those who agree with us, but freedom for
the thought that we hate." - Oliver Wendell Holmes