Select only rows with minimum values from union table
You can treat the union as a subquery. 

SELECT TOP 1 DBID, UPC, Price1, Price2
FROM (SELECT DBID, UPC, Price1, Price2 
    FROM Table1
    UNION 
    SELECT DBID, UPC, Price1, Price2 
    FROM Table2) sub 
ORDER BY Price1 DESC