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 likeCompanyname* address* address...Companyname* address ...I have a join query to retrieve that kind of information, which gives me rows withcompanyname1, address1companyname1, address2companyname2, address1companyname3, ....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 ?
Bundled information
- Thread starter wxdqz
- Start date