presenting database info

[nightowl]

I have two tables, one with all kinds of companies, one with the addresses (1 company can have multiple addresses). So I have a one-to-many relation.
What I want to do is use these two tables to present the information like
Companyname
address
address
...
Companyname
* address
...
I have a join query to retrieve that kind of information, which gives me rows with
companyname1, address1
companyname1, address2
companyname2, address1
companyname3, ....
How can I format the information of those tables in the way I want (described above)? How do I determine if a new company starts? Or is my query wrong ?

[[deleted]]

"How do I determine if a new company starts?"

...by checking if the company from the current row that you are printing is the same as, or different from the company in the revious row.