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. Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.