I'm using Mysql with PHP and I was wondering if there's a query for mysql. I have a list of say authors and each author may have several books listed I only want to list each author once in the query no duplications.So can this be done in one query.
Check the mysql manual or any book on SQL and read about "SELECT DISTINCT". It does exactly what you want.
