I have a table that I am querying some tables from and wanting to pull the last date. However, sometimes this date is the same. Example, a PO that was last received on the same day for same Item.
How could I create my query that if the "Received_Date" is the same, then look at the "Want_Date" instead?
select item_id, Unit_price, Want_date, Received_date
Not sure how to tweak the above query that if "Received_Date" is the same, then look at "Want_date" and only pull the most recent. Any ideas?