title: When fetching data from multiple tables it is not showing any error however i am not able to retrieve the data
body: <pre><code>String get_date = txt_check_in_date.getText().trim();
          String get_customer_no = txt_customer_no.getText().trim();
          Connection conn = null;
          PreparedStatement pstmt = null;
          ResultSet rst = null;
          try{
              String driver ="com.mysql.jdbc.Driver";
              String url ="jdbc:mysql://localhost:3306/hotel";
              String userid ="root";
              String password ="tushar11";
              Class.forName(driver);
              conn = DriverManager.getConnection(url,userid,password);
              pstmt = conn.prepareStatement("select occupantdetails.customer_name, hoteldetails.service_detail, hoteldetails.room_no from occupantdetails JOIN hoteldetails ON occupantdetails.customer_no=hoteldetails.customer_no where occupantdetails.customer_no=? AND occupantdetails.check_in_date=? " );
              pstmt.setString(1, get_date);
              pstmt.setString(2, get_customer_no);
  
  
  
              rst = pstmt.executeQuery();
              while(rst.next()){
                  txt_customer_name.setText(rst.getString("customer_name"));
                  txt_room_no.setText(rst.getString("service_detail"));
                  txt_cab_no.setText(rst.getString("room_no"));
              }
  </code></pre>
  
  <p>when i run the file and fill in the parameters it is not showing any error and the execution stops. And no result is displayed.</p>