vicodin Posted May 3, 2009 Share Posted May 3, 2009 I have 2 tables. They both have the same column names. What im looking to do is compare one table to the other. So I have a column in both tables that have zip codes in them and in another column there is a rate. I need a statement that compares the rates on both tables and then outputs the column info that has the lower rate. Any help would be greatly appreciated! Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/156612-mysql-statement/ Share on other sites More sharing options...
Ken2k7 Posted May 3, 2009 Share Posted May 3, 2009 Can you post what you have currently? Quote Link to comment https://forums.phpfreaks.com/topic/156612-mysql-statement/#findComment-824684 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.