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
