Here is my SQL Statement created in Wintegrate for Universe.
* SQL Statement
SQLBuilder.ESelect=`SI.BROKER,SUM(SI.F14)`
SQLBuilder.EFrom=`SI`
SQLBuilder.EWhere=`SI.PERIOD = <<Enter Period as 'YY-MM'>>    `
SQLBuilder.EGroup=`SI.BROKER`
SQLBuilder.EOrder=`SI.BROKER DESC`
SQLBuilder.EFrom=`SI`
SQLBuilder.EHeading=``
SQLBuilder.EFooting=``
SQLBuilder.OutputTo=`Screen`
I need help on the following:
1.What syntax I should use to select for a specific Broker Code (Alpha 
Numeric).  
2. If I want to add the field SI.CUSTOMER.ID, what syntax to use to get total 
by CUSTOMER.ID and also total by GROUP for each BROKER in the same statement.

Krish

_______________________________________________
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to