richardstan Posted November 19, 2010 Share Posted November 19, 2010 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. Link to comment https://forums.phpfreaks.com/topic/219235-finding-minimum-value-from-two-tables/ Share on other sites More sharing options...
Hybride Posted November 19, 2010 Share Posted November 19, 2010 Did you try the MySQL comparison or a quick search for a generic MySQL cheat sheet? Link to comment https://forums.phpfreaks.com/topic/219235-finding-minimum-value-from-two-tables/#findComment-1136901 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.