I have two tables, one with a list of columns relating to the hotels that a tourist will stay on during their trip and the other the details of the hotel.
This is a sample of the trip data
Id HotelOne HotelOneDuration HotelOneCheckIn HotelTwo HotelTwoDuration HotelTwoCheckIn HotelThree HotelThreeDuration HotelThreeCheckIn
44 129 3 2012-12-15 127 5 2012-12-19 No Hotel 0 0001-01-01
And this the hotel data.
Id HotelName HotelImage HotelText Location StarRatiing
129 Marriott pic.jpg xxx 1 3
127 Golf Resort golf-resort.jpg yyy 1 5
What I'd like to do is pull the hotel data out in rows if possible. Something like this
Position HotelName HotelText Duration CheckIn
1 Marriott xxx 3 2012-12-15
2 Golf Resort yyy 5 2012-12-19
Is it possible to pull the data out the database like this. Or should I just sort it out in the code.