Hello there ,
I’m creating booking system with wappler . But I need to list all available rooms . I have a query like this
SELECT * FROM rooms WHERE id NOT IN (SELECT * FROM events WHERE ( start<= '$dateout' AND end >= '$datein )
How can I create this query in query builder.
Please guide me …