**I am having problem on an attempt to join two tables in oracle and showing the value.**

What my code looks like this:

```
 if ($_POST['action'] == 'show'){

        $requestCompSql = "SELECT REQUEST_COMPONENT_CUTTING.PROJECT_NAME, 
                                  REQUEST_COMPONENT_CUTTING.BASE_PLATE, 
                                  REQUEST_COMPONENT_CUTTING.THICKNESS, 
                                    COMPONENT.CUTTING.QTY_REQUIRED,
                                  REQUEST_COMPONENT_CUTTING.QTY_REQUESTED
                                  REQUEST_COMPONENT_CUTTING.REQUESTER, 
                                  REQUEST_COMPONENT_CUTTING.REQUEST_DATE 
                                        FROM REQUEST_COMPONENT_CUTTING
                                        INNER JOIN COMPONENT_CUTTING
                                  ON REQUEST_COMPONENT_CUTTING.PROJECT_NAME = COMPONENT_CUTTING.PROJECT_NAME
                                    AND REQUEST_COMPONENT_CUTTING.THICKNESS = COMPONENT_CUTTING.THICKNESS
                                    AND REQUEST_COMPONENT_CUTTING.BASE_PLATE = COMPONENT_CUTTING.BASE_PLATE = '{$_POST["bp"]}'";

        $requestCompParse = oci_parse($conn, $requestCompSql);

        oci_execute($requestCompParse);

        while($row = oci_fetch_assoc($requestCompParse)){

        echo "<div class='table-responsive'>";
        echo "<table class='table table-bordered'>";
                                echo '<table cellspacing = "0"';
                                    echo '<thead>';
                                    echo '<tr>
                                              <th>PROJECT</th>
                                              <th>BASEPLATE</th>
                                              <th>THICK</th>
                                              <th>QTY REQUESTED</th>
                                              <th>QTY REQUIRED</th>
                                              <th>REQUESTER</th>
                                              <th>REQ. DATE</th>
                                              <th align="center">ACTION</th>  
                                          </tr>
                                          </thead>';

                                     echo "<tbody>";
                                        echo "<tr class='warning'><td>$row[PROJECT_NAME]</td>";
                                        echo "<td>$row[BASE_PLATE]</td>";
                                        echo "<td>$row[THICKNESS]</td>";
                                        echo "<td>$row[QTY_REQUESTED]</td>";
                                        echo "<td>$row[QTY_REQUIRED]</td>";
                                        echo "<td>$row[REQUESTER]</td>";
                                        echo "<td>$row[REQUEST_DATE]</td>";
                                        echo "<td><input type='button' value='OK' class='btn btn-success'>
                                            <input type='button' value='REJECT' class='btn btn-danger'></td>";

                                        echo "</tr>";
                                     echo "</tbody>";
                                 echo "<table cellspacing = '0'";
                                 echo "</div>";
        }

    }

```

and the error message given is like this:

> 
> Warning: oci\_execute(): ORA-00923: FROM keyword not found where expected in C:\xampp\htdocs\WeltesInformationCenter\Component\_approval\show\_requested\_component.php on line 60
> 
> 
> Warning: oci\_fetch\_assoc(): ORA-24374: define not done before fetch or execute and fetch in C:\xampp\htdocs\WeltesInformationCenter\Component\_approval\show\_requested\_component.php on line 62
> 
> 
> 

I've been so frustrated with this because the `QTY_REQUIRED` value must be based on `PROJECT_NAME`, `THICKNESS` and `BASE_PLATE`