Im having a crisis with this query of mine:

```
SELECT
    `tbl_beds`.`Bed_No`
    , `tbl_bedrest`.`Time_In`
    , `tbl_bedrest`.`Time_Out`
FROM
    `csbdb2`.`tbl_bedrest`
    INNER JOIN `csbdb2`.`tbl_beds` 
        ON (`tbl_bedrest`.`Bed_ID` = `tbl_beds`.`Bed_ID`)
WHERE 
    CURRENT_TIMESTAMP BETWEEN `tbl_bedrest`.time_in AND `tbl_bedrest`.time_out
    GROUP BY `tbl_beds`.`Bed_No`

```

What im looking for is to get All of the beds and display them even if they are occupied or not within the CURRENT\_TIMESTAMP:

```
+-----------+---------------------+---------------------+
| bed_id    | time_in             | time_out            |
+-----------+---------------------+---------------------+
| BED000001 |                null |                null |
| BED000002 | 2016-01-14 09:00:00 | 2016-01-14 15:00:00 |
| BED000003 | 2016-01-14 06:00:00 | 2016-01-14 09:00:00 |
| BED000004 | 2016-01-14 09:55:07 | 2016-01-14 09:51:45 |
| BED000005 | 2016-01-14 10:00:18 | 2016-01-14 09:57:54 |
+-----------+---------------------+---------------------+

```

Here are my tables:

tbl\_Beds

```
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Bed_ID   | varchar(10) | NO   | PRI | NULL    |       |
| Bed_No   | varchar(10) | YES  |     | NULL    |       |
| Building | varchar(10) | NO   | PRI | NULL    |       |
+----------+-------------+------+-----+---------+-------+

```

tbl\_bedrest

```
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| BedRest_ID | varchar(10) | NO   | PRI | NULL    |       |
| Time_In    | datetime    | YES  |     | NULL    |       |
| Time_Out   | datetime    | YES  |     | NULL    |       |
| Case_ID    | varchar(10) | NO   | PRI | NULL    |       |
| Bed_ID     | varchar(10) | NO   | PRI | NULL    |       |
+------------+-------------+------+-----+---------+-------+

```