I have a BusinessID in both my staff and business table and I'm wanting to display the staff members for everyone in a particular business. The query below gives me this error.

```
ERROR: Could not able to execute SELECT * FROM business b inner join BusinessID b ON b.BusinessID = s.BusinessID WHERE b.BusinessID = 1. Not unique table/alias: 'b'

```

This is my foreign key file

```
<html>

<body>

<?php

include_once("connect.php");

$BusinessID = $_GET['BusinessID'];

$sql=   "SELECT *
        FROM business b
        inner join BusinessID b
        ON b.BusinessID = s.BusinessID
        WHERE b.BusinessID = $BusinessID"; 

if($result = $conn->query($sql)){
    if($result->num_rows > 0){
        echo "<table>";
            echo "<tr>";
                echo "<th>Name</th>";
                echo "<th>BusinessID<th>";
            echo "</tr>";
        while($row = $result->fetch_array()){
            echo "<tr>";
                echo "<td>" . $row['Name'] . "</td>";  
                echo "<td>" . $row['BusinessID'] . "</td>";
            echo "</tr>";
        }
        echo "</table>";
        // Free result set
        $result->free();
    } else{
        echo "No records matching your query were found.";
    }
} else{
    echo "ERROR: Could not able to execute $sql. " . $conn->error;
}

// Close connection
$conn->close();
?>

    </body>

</html>

```

Below is the fix

```
$sql=   "SELECT *
        FROM staff 
         WHERE BusinessID = $BusinessID"; 

```