I have this:
T-1       T-2          T-3       
pkID     pkID        pkID
f1          f1             f1
f2          f2             f2
             t1FK        t1FK


t-1 Data
1    Joe   admin

t-2  Data                 fkid
1    Grape   200       1

t-3    Data                fkid
1        1         0          1
2        0         1          1

Ok  t-1 join t-2 and t-3

When I make the query I got:

1   Joe   admin   Grape  200     1 0
1   Joe   admin   Grape  200     0 1 


The problem is if I make a sum for a field 5 in the query I got 400 what is
bad because I have 200.

I want This result in a group query:
1  Joe    Admin    Grape   200   1   1

OBJECTPROPERTY problem
T-SQL: How to loop through the resultset from another procedure?
Count Occurances in a column
Who has the highest bid?
Need Help Please...