<div>
SELECT <br />
&nbsp; &nbsp; &nbsp;SUM(QTY) TOTALQTY,<br />
&nbsp; &nbsp; &nbsp;CUST_ID<br />
FROM <br />
&nbsp; &nbsp; &nbsp;&lt;table_name&gt;<br />
GROUP BY <br />
&nbsp; &nbsp; &nbsp;CUST_ID
</div>


SELECT
     SUM(QTY) TOTALQTY,
     CUST_ID
FROM
     <table_name>
GROUP BY
     CUST_ID

<div>
<div class="content wysiwyg-content">
I need to a select statement that will pull the qty together for the same cust_id<br />
<br />
what I have...<br />
log_id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; qty &nbsp; &nbsp; &nbsp; &nbsp;cust_id<br />
1047 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36134<br />
1048 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36134<br />
1049 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3332<br />
<br />
result...<br />
cust_id &nbsp; &nbsp; qty<br />
36134 &nbsp; &nbsp; &nbsp; 2<br />
3332 &nbsp; &nbsp; &nbsp; &nbsp; 4
</div>
</div>


I need to a select statement that will pull the qty together for the same cust_id

what I have...
log_id           qty        cust_id
1047	1          36134
1048	1          36134
1049              4          3332

result...
cust_id     qty
36134       2
3332         4

select statement that adds values

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.