Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    Unanswered: remove ShippingCharge and TaxCharge from Total using sql

    hello,
    how to remove ShippingCharge and TaxCharge from Total using sql?

    I need to select all data from a table
    where Total is => $50
    before the ShippingCharge and TaxCharge were appld.

    Select Total
    from ord
    where (Total - ShippingCharge - TaxCharge) => $50


    Thank you

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    => -> >=


  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    heh, that looks a little like brainfcuk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •