2 Tables, get lowest number

[Tore Brukstuen]

Hello,

tried to look around, tested tons of code, but as a newbie with mysql I'm not able to fix this myself. I want to learn, but I'm stuck.

I have 2 tables - customers and orders.
From the customers table I need to grab & sort the name of the costumers (cname) together with the order number (ono).

customers have cno, cname
orders have cno, ono.

Question:
Any idea how I can get the lowest values from (count) ono and the name linked to it?


-Thanks