dootch Posted January 25, 2007 Share Posted January 25, 2007 I have 2 tables from different sources they both have 3 field's in common (man_id, prod_id, price) what i want to do is compare the tables if the prod_id matches, output to another table the man_id, prod_id and price of the one with the lowest price. I am trying to figure out what would be the best way to accomplish this task. Any help would be appreciated. Link to comment https://forums.phpfreaks.com/topic/35694-using-php-to-compare-mysql-tables/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.