hierarchy structure

hello!
I have a hierarchy structure copied from excel to a table in databse SQL.
Here is what i have in SQL table:

Continent Country City

Europe
Norway
Oslo
Bergen
Trondheim
Sweden
Stockholm
Gotaborg
Denmark
Kopenhagen
Aalborg
Germany
Hamburg
Munchen
Hannover

Asia
Japan
Tokyo
Hirroshima
Kina
Shanghai
Africa
South-Africa
Pretoria

AND her is what i want

Continent Country City

Europe
Europe Norway
Europe Norway Oslo
Europe Norway Bergen
Europe Norway Trondheim
Europe Sweden
Europe Sweden Stockholm
Europe Sweden Gotaborg
Europe Denmark
Europe Denmark Kopenhagen
Europe Denmark Aalborg
Europe Germany
Europe Germany Hamburg
Europe Germany Munchen
Europe Germany Hannover

Asia
Asia Japan
Asia Japan Tokyo
Asia Japan Hirroshima
Asia Kina
Asia Kina Shanghai
Africa Kina
Africa South-Africa
Africa South-Africa Pretoria

How do i that?



.

Relevant Pages

  • Suggestion for WC 2010 qualifying format
    ... I feel Africa, NA and Asia have too many spots now and none of these ... teams are from Europe and SA where soccer is played and watched the ... Slovakia lost in play offs to Spain. ...
    (rec.sport.soccer)
  • Re: Suggestion for WC 2010 qualifying format
    ... I feel Africa, NA and Asia have too many spots now and none of these ... teams are from Europe and SA where soccer is played and watched the ... Slovakia lost in play offs to Spain. ...
    (rec.sport.soccer)
  • Re: (Negro) Train Defecator Hunted
    ... and more intense parental care of the young in Europe and Asia. ... Africa, the reproductive strategy was to produce more children. ... The White reproduction strategy, on the other hand, are like snipers. ...
    (uk.politics.misc)
  • Re: Verizon/GSM/Used Phone
    ... phone on the appropriate frequencies for Europe, Africa, Asia, and the ... I'd traveled to Greece, I'd gotten a rental Verizon phone, which ...
    (alt.cellular.verizon)
  • Re: Travel to Thailand possible now?
    ... http://www.molon.de - Photos of Asia, Africa and Europe ...
    (rec.travel.asia)