2 Replies Latest reply on Sep 29, 2015 1:10 AM by kstirto

    Conditional Selecting Values of a Field Based on Logical Condition

    kstirto

      Dear members, I need some help here after pulling my hair this past 2 days... I have "Customer" table with IsReseller field as Boolean. I also have "Products" table with 2 numeric fields: SellerPrice and ResellerPrice. In my "OrderLineItems" table I have a field called UnitPrice that I would like to select and copy the value of ResellerPrice if the IsReseller = True and copy the SellerPrice if IsReseller is False. How could I achieve this? Thanks