petergroot
Programmer
Hi,
I have a Produkt table with 2 prices (ordinary price and special offer price) in the table there is also a boolean which determines if the produkt is on sale or not.
Now i want to write an SQL line that pulls out the Special Offerprice when the boolean is true.
I understand that i need the case function, but how do i use that?
I want to create a new field called Sold Price.
Thanks in Advance, Peter
I have a Produkt table with 2 prices (ordinary price and special offer price) in the table there is also a boolean which determines if the produkt is on sale or not.
Now i want to write an SQL line that pulls out the Special Offerprice when the boolean is true.
I understand that i need the case function, but how do i use that?
I want to create a new field called Sold Price.
Thanks in Advance, Peter