Test2 table query
SELECT common_name AS "Common name", scientific_name AS "Scientific name", DATE, location, note, id FROM species ORDER BY scientific_name;
dbquery/test2.txt · Last modified: by Richard White
$[hdcolor $\brown$\$]
Friends of Bishop's Pond (bishopspond.uk)
Fordingbridge Conservation Group (fordingbridgeconservation.uk)
$[/hdcolor$]
SELECT common_name AS "Common name", scientific_name AS "Scientific name", DATE, location, note, id FROM species ORDER BY scientific_name;