Post reply

multiple where clauses

  • June 11, 2010 at 4:43 pm

    #223792

    I need to get the total dollar amount of checking for these branches but having problems with the query:

    select sum(bibal),count(acct) from cb_nd_daily

    where dt='06/10/10'

    and br between 201 and 238 ------This is my question

    and br in (291,292)----->

    Of course I get no data returned because of the "br values" is incorrect. How can I pull br(branches) 201 thru 238,291, and 292?

    Your assistance is much appreciated. Thanns

  • June 11, 2010 at 6:26 pm

    #1179496

    select sum(bibal),count(acct)

    from cb_nd_daily

    where (dt='06/10/10')

    and (

    (br between 201 and 238) or (br in (291,292))

    )

  • June 11, 2010 at 9:43 pm

    #1179506

    Thanks let me give that a try on Monday

  • June 14, 2010 at 10:36 am

    #1179994

    Thanks that worked.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply