Complicated Sum()

[user4fun]

I need to write a query statment that will do the following$sql1="Select PK_BusinessID FROM tblBusiness where FK_AccountID ='$ses_var_PKAccountID' ";The trick is I want to find the SUM(Max_Ad_Pts) FROM tblAd for every PK_BusinessID that is found from $sql1 and just return one results $total_Max_Pts.I would apprecaite any help I can get.Thank you

[justsomeguy]

$sql1="SELECT SUM(Max_Ad_Pts) FROM tblAd WHERE PK_BusinessID IN (Select PK_BusinessID FROM tblBusiness where FK_AccountID ='$ses_var_PKAccountID') ";