I have a table with two columns "AuctionPrice" and "BINPrice". Some Auctions also have a BINPrice too (Buy It Now Price).
I need to sort by lowest and highest prices, very similar to how eBay does it. This is what I've gotten so far:
ORDER BY AuctionPrice DESC, BINPrice DESC
This doesn't seem to be working. I have a feeling both price columns need to be combined somehow but I'm not sure.
Let me know how this could be done.
ORDER BY COALESCE(BINprice,AuctionPrice ) DESC
Awesome! Thanks a lot for the help.
so i made a lucky guess