richardstan

I have two tables, representing two different shops that have a list of stock. Both shops sell milk, but at different prices. How can I use mysql to compare the values in the two different tables and return the lowest one for the price of milk? Thanks.