November 10th, 2013, 04:07 AM
SQL (Simple?) REQUEST PROBLEM - Urgent
November 10th, 2013, 05:38 AM
1. Start with the product table and target the product you're searching on.
2. Then JOIN in the corresponding room table.
3. Then JOIN in the room table again that matches the same city. You might want to exclude the same room you started with, I don't know.
4. Then JOIN in the products table on that second set of rooms, making sure to exclude the product you started with. This is where you get the matching product information from.
That'll take care of the "same city" problem, but I'm not sure how you want to deal with the "same date" since it's apparently a range (comes in as a start and end date). Same date range? Overlapping dates?
November 10th, 2013, 07:19 AM
November 10th, 2013, 08:31 AM
November 10th, 2013, 04:51 PM
And thank you to all for have answer to me.
As you could see I am not very good in sql language, and I really need the request before tuesday.
Could you give me it please? I should be very simple but for me it's the Everest...
I am in the ****.. lol
November 10th, 2013, 04:58 PM
not until you clear up the requirements for date matching
Originally Posted by MuSQLor
and maybe not then, either