wel51x - 6:23 am on Jun 9, 2011 (gmt 0)

thanks for the welcome.

here's the code (note the table "country" has three columns: Country, Language and Population):

SELECT `Language` , `Country`
FROM `country`
ORDER BY `Language` , `Country` ASC;

This produces the following output:

English || Canada
English || Isle of Man
English || United Kingdom
English || United States
French || France
French || Morocco
Portugese || Brazil
Russian || Ukraine
Spanish || Argentina
Spanish || Mexico
Spanish || Peru
Tagalog || Philippines

NOTE: " || " is used to denote th delimeter - it does NOT appear in the output.

what I want to see is this:

English || Canada
|| Isle of Man
|| United Kingdom
|| United States
French || France
|| Morocco
Portugese || Brazil
Russian || Ukraine
Spanish || Argentina
|| Mexico
|| Peru
Tagalog || Philippines

in other words the 'Language' column appears on;ly in the FIRST row.