Yohanne Posted April 11, 2013 Share Posted April 11, 2013 i have this "SELECT DISTINCT ocs_admin_new_item.cat_id,ocs_admin_new_item.prd_name,ocs_category.cat_id,ocs_category.cat_name FROM ocs_admin_new_item INNER JOIN ocs_category ON ocs_admin_new_item.cat_id = ocs_category.cat_id ORDER BY prd_name" now how can i DISTINCT the cat_id? where i have two table that i join? Link to comment https://forums.phpfreaks.com/topic/276814-distinct-id/ Share on other sites More sharing options...
fenway Posted April 13, 2013 Share Posted April 13, 2013 You can't apply DISTINCT to a particular column -- it operates at the record-level. What are you trying to do? Link to comment https://forums.phpfreaks.com/topic/276814-distinct-id/#findComment-1424590 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.