I have two tables with similar data but entirely different column names. I make the query in a PHP page and then use the data in echo statements like this:

```
<?php echo($row['bedrooms']); ?>

```

The current query looks like this:

```
$sql_query = "SELECT mls_number, city, list_price, bedrooms 
                  FROM bonita_property_res 
                  WHERE city = "Bonita" AND list_price >= 1500000 
                  ORDER BY list_price DESC";

```

How do a join a table called naples\_property\_res that looks like this and still be able to use the php echo as its configured?

```
MLSNumber     City       ListPrice      TotalBeds
--------------------------------------------------
898989   | Bonita    | 200000     |  4

```