Below mention query will fulfill your requirement: SELECT ACCOUNT WITH GROUP-NUMBER EQ "" AND BALANCE GT "20.00"
*--* * Regards,* Ali Javaid Hussain Cell # +92-300-2760352 | Cell # +92-321-8254352 Text: +92-321-8254352 | E: [email protected] On Wed, Jan 26, 2011 at 11:51 PM, Shay Simmons <[email protected]>wrote: > Is there a way to accomplish the following query without using any > parentheses? When I attempt it with parentheses, i get an error message to > the effect that dictionary item ")" does not exist. > > SELECT ACCOUNT (WITH GROUP-NUMBER "" AND BALANCE > "10.00") OR (WITH > GROUP-NUMBER AND GROUP-BALANCE > "20.00") > > Any help you can provide would be much appreciated. > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
