peppy — 2011-08-18T02:14:33-04:00 — #1
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.
r937 — 2011-08-18T03:11:28-04:00 — #2
ORDER BY COALESCE(BINprice,AuctionPrice ) DESC
peppy — 2011-08-18T15:25:30-04:00 — #3
Awesome! Thanks a lot for the help.
r937 — 2011-08-18T16:45:56-04:00 — #4
so i made a lucky guess