I have 3 tables where I want to grab a date from and I made a case statement for it. Is it possible for me to grab the Min date as I get multiple values for the date and I only want to grab that one? Here is my code so far. Thanks for anyone if they can help.
SELECT PURC_ORDER_LINE.PART_ID...