Hi I have two tables in Hive with some product sales details
i want to find in which table one product is sold in lesser price Tables consists of (id,date,product,quantity,price,address) two table have same schema date is the primary and foreign keys in two tables. I want to find in which table Iphone is Sold in lesser price