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