How do I get a result across 2 tables

by

Use a basic INNER JOIN to achieve that.

SELECT b.*
FROM booking b INNER JOIN room r USING(RoomID)
WHERE @date_input BETWEEN startdate AND enddate AND size = @size_input;

Change @date_input and @size_input to your real input.

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Multiple queries executed in java in single statement
  3. MySQL and JDBC with rewriteBatchedStatements=true
  4. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  5. right syntax to use near ‘?’
  6. Running a .sql script using MySQL with JDBC
  7. Prevent SQL injection attacks in a Java program
  8. LINQ for Java tool [closed]
  9. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  10. How to use prepared statement for select query in Java?
  11. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  12. Hibernate Criteria API: get n random rows
  13. Getting last record from mysql
  14. MySQL query to get Records in Result set
  15. How to get UTF-8 working in Java webapps?
  16. How do I get the size of a java.sql.ResultSet?
  17. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  18. How to configure Tomcat to connect with MySQL
  19. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Software caused connection abort: recv failed [duplicate]
  20. dll missing in JDBC
  21. Is there a way to run MySQL in-memory for JUnit test cases?
  22. Inserting null to an Integer column using JDBC
  23. How to implement a SQL like ‘LIKE’ operator in java?
  24. java.sql.SQLException: Before start of result set [duplicate]
  25. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  26. How to setup Hibernate to read/write to different datasources?
  27. JDBC MySQL connection using Unix Socket
  28. Unable to get multiple Table entities through Stored procedure using hibernate
  29. JDBC connection error : unrecognized timezone [duplicate]
  30. Searching between dates in SQL with JDBC?

Leave a Comment