# MySQL Joining Tables - Display (PLEASE HELP)

**URL:** <https://forum.kirupa.com/t/mysql-joining-tables-display-please-help/302429>\
**Category:** programming\
**Created:** [December 30, 2009, 1:00pm UTC](https://forum.kirupa.com/t/mysql-joining-tables-display-please-help/302429 "2009-12-30T13:00:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wispas](https://avatars.discourse-cdn.com/v4/letter/w/9de0a6/32.png) [@wispas](https://forum.kirupa.com/u/wispas)\
**Post date:** [December 30, 2009, 1:00pm UTC](https://forum.kirupa.com/t/mysql-joining-tables-display-please-help/302429/1 "2009-12-30T13:00:28Z")

</div>

I currently have two tables in my MySQL database.  
City and Hotel are the tables.

I have several rows of hotels which includes fields such as hotel\_id, hotel\_name, hotel\_address.

I want these hotels to be associated to the cities and display 3 hotels for each city…  
Therefore in the City table i have i have included 3 fields called hotel\_1, hotel\_2 and hotel\_3.  
In each of the field i have placed the ID (hotel\_id) of the hotel i want to display.

I want write a query that will display the hotels for that city.  
Please help!