Help With Subquery

Trying to add subquery to get only the Goal amounts where consolidated id= 32. In the main query im grabing consolidated_id (5 , 6, and 8) , thats the only difference between the two. Same tables and everything. How do i get the same amount of records so it looks like this:
Amount Goal Amount Year Period Brand
1597.50 3000 2008 2 Pro Large
1425.00 2500 2008 2 Pro Medium
500.00 3000 2008 2 Pro Large
475.00 4000 2008 1 Pro Large
237.50 4000 2008 1 Pro Large







Code Snippet
SELECT
cusSales.Customer_Sales_Summary_Amount as Amount,
Goals.Goal_Amount,
cusSales.Customer_Sales_Summary_Year as Year,
cusSales.Customer_Sales_Summary_Period As Period,
cusSales.Consolidated_Sales_Tables_Id as Table_id,
cusSales.Customer_Code,
cusSales.Sub_Brand_Id,
cusSales.Report_Level_Description,
cusSales.Report_Level_Id,
Qry_Report_Level_Brand.Sub_Brand_Description,
RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Company_Name,
RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Division_Name,
RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Group_Name,
RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Territory_Zone,
cusSales.Bill_Customer_Code
FROM RC_DWDB_INSTANCE_1.dbo.Tbl_Customer_Sales_Summary_Fiscal AS cusSales
INNER JOIN RC_DWDB_INSTANCE_1.dbo.Tbl_Territory_In_Customer
ON cusSales.Customer_Code = RC_DWDB_INSTANCE_1.dbo.Tbl_Territory_In_Customer.Customer_Code
INNER JOIN RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension
ON RC_DWDB_INSTANCE_1.dbo.Tbl_Territory_In_Customer.Territory_Code = RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Territory_Code
INNER JOIN Qry_Report_Level_Brand
ON cusSales.Sub_Brand_Id = Qry_Report_Level_Brand.Sub_Brand_Id
---SUB QUERY FOR GOALS---
INNER JOIN (SELECT
cusSales.Customer_Sales_Summary_Amount AS Goal_Amount,
cusSales.Customer_Sales_Summary_Year AS Year,
cusSales.Customer_Sales_Summary_Period AS Period,
cusSales.Report_Level_Id,
cusSales.Consolidated_Sales_Tables_Id as Table_id


FROM RC_DWDB_INSTANCE_1.dbo.Tbl_Customer_Sales_Summary_Fiscal AS cusSales
INNER JOIN RC_DWDB_INSTANCE_1.dbo.Tbl_Territory_In_Customer
ON cusSales.Customer_Code = RC_DWDB_INSTANCE_1.dbo.Tbl_Territory_In_Customer.Customer_Code
INNER JOIN RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension
ON RC_DWDB_INSTANCE_1.dbo.Tbl_Territory_In_Customer.Territory_Code = RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Territory_Code
INNER JOIN Qry_Report_Level_Brand
ON cusSales.Sub_Brand_Id = Qry_Report_Level_Brand.Sub_Brand_Id
WHERE (cusSales.Report_Level_Id = 85) AND (cusSales.Customer_Sales_Summary_Year = 2008) AND
(RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Group_Name <> 'National') AND
(RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Company_Name = 'RC USA') AND (cusSales.Consolidated_Sales_Tables_Id = 32)
)Goals
ON Goals.Year=cusSales.Customer_Sales_summary_year
AND Goals.Period=cusSales.Customer_sales_summary_period
AND Goals.Report_Level_Id=Qry_Report_Level_Brand.Report_Level_Id



WHERE (cusSales.Consolidated_Sales_Tables_Id IN (5, 6, 8)) AND (cusSales.Report_Level_Id = 85) AND (cusSales.Customer_Sales_Summary_Year IN (2007,
2008)) AND (RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Group_Name <> 'National') AND
(RC_DWDB_INSTANCE_1.dbo.Qry_Sales_Group_Dimension.Company_Name = 'RC USA')