What do you mean by 'listview' - a listbox?
You have two ways to accomplish.
First one
1. have a dataset with all possible fruit - a 'master' table; if you don't have one it can be created with UNION:
SELECT ID FROM Testing UNION ID FROM Testing1;
2. build two aggregate queries that summarize each table
3. join the two aggregate queries to 'master', I think it will be a LEFT JOIN for each link
Second one
1. start with a UNION query
SELECT 1 AS Source, ID, Awarded FROM Testing
UNION ALL SELECT 2, ID, Awarded FROM Testing1;
2. use that query as source for a CROSSTAB
or emulate a CROSSTAB
SELECT ID, Sum(IIf(Source=1,Awarded,Null)) AS SubTotal, Sum(IIf(Source=2,Awarded,Null)) AS SubTotal1 FROM qryUNION GROUP BY ID;