I have two tables like the following

```
hotels
------
hotelID
hotelName

```

Second table

```
operators
---------
opID
opName
opServices
opHotelID

```

a short explanation: In the first table I have a lot of hotels which have an increment id which is unique. The second table contains all the operators offering this hotel with additional services. The opID here is unique too but the opHotelID exists multiple times, because there can be many operators offering the hotel.

Now, what I want to get is the following:

I want to get the HotelName and an additional Column (called Operators) which lists all the operators offering the hotel.

So the result should be like this...

```
123 - Hotel ABC - OP1,Op2,OP3

```

instead of this...

```
123 - Hotel ABC - OP1
123 - HOtel ABC - OP2
123 - Hotel ABC - OP3

```

Is there a way to do this in one SQL query or how would you solve this problem? I am currently working on a search function and currently i have a simple SELECT query with a left join but this returns a lot of more rows. Now the Search should only display unique HotelIDs and combine the different Operators in one column.

Thanks for you help and have a nice day...

Bye
WorldSignia