Hi Rudy, thanks for your support. It's working like charm, but I need to slightly extend the query and I don't have a glue how to get this managed.
The table rental has a column called active, which indicates whether a rental object is available to the public or not; so I need to extend the query by the condition.
But I'm not sure where to put this peace of code to!
And the second extension; a table holding the descriptions of each rental object in all available languages called rental_desc where I need the column Claim. This table has the Foreign Key Rental_ID to make the relation to the rental object. To me on a former query it just was a join, like:
AND rental.ID=rental_desc.Rental_ID AND Lng='1'
But after so much derivatives I'm not sure where to put this code also.
Thanks and Merry Christmas to you and your family and a good New Year