Displaying a table column in addition to query results
I am running the following MySQL query:
SELECT COUNT(*), OldCompanyName, NewCompanyName FROM moortown5
GROUP BY OldCompanyName, NewCompanyName
This successfully returns matches and partial matches from the required column.
My problem is this. I want to display a column called 'Records' along with the results so that I know which table row the results belong to.
Can anyone help?
Thanks very much in advance.:confused:
I believe I need to display the 'Records' column by default with all query results somehow?