I have the following code for selecting from multiple tables where the order number matches. 

```
$orderNumber = $_GET['orderNumber'];

$sql = $db->prepare("
                    SELECT
                        *
                    from `KC_Orders`
                        INNER JOIN
                            `KC_Payments`
                            on KC_Orders.orderNumber = KC_Payments.orderNumber
                        INNER JOIN
                            `KC_OrderStatus`
                            on KC_Orders.orderNumber = KC_OrderStatus.orderNumber
                        INNER JOIN
                            `KC_Statuses`
                            on KC_OrderStatus.statusID = KC_Statuses.statusID
                    WHERE
                        orderNumber= :orderNumber");

$sql->execute(array(':orderNumber' => $orderNumber));
$orderInfo = $sql->fetchAll();

```

Now when I `var_dump($orderInfo);` it returns: `array(0) { }` What is wrong? All the tables include the same `$orderNumber` field within it. If I take the WHERE part out it works just fine except it returns every row not just one. (obviosly). 

Please help us!