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? Quote Link to comment 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? Quote Link to comment 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.