nishto

I want to fetch invoice data from two tables

table a is in single row and table b data should be multiple rows

single data is fetching correctly but facing problem with table 2 multiple data fetch.

php file

<?php   

$connection= mysqli_connect("localhost","root","","invoice");

  $invID = $_POST['ID'];

     $Invo = "SELECT a.in_no, a.client, a.add, a.Date, a.subTotal a.gTotal, 
      b.id, b.item, b.quantity, b.price from invoice a, invoiceItems b where a.in_no = b.in_id AND  in_no = '$invID' ";

 $runQuery = $connection->query( $Invo);

if($runQuery->num_rows > 0) { 
$result = $runQuery->fetch_array();
} // if num_rows

$connection->close();
echo json_encode($result);
?>

js file

function Invoice (ID = null) {

if(ID) {
    $.ajax({
        url: 'fetch.php',
        type: 'post',
        data: {ID: ID},
        dataType: 'json',
        success:function(response) {

            // invoice id 
            $(".footerClass").append('<input type="hidden" name="invoId" id="iD" value="'+response.in_no+'" />');

            // invoice no
            $("#No").val(response.in_no);
            // Name
            $("#Name").val(response.client);
            // pat.Address
            $("#Add").val(response.add);
            // invoice date
            $("#Date").val(response.Date);

            $('#item_'+id[1]).val(response.item);               
            $('#quantity').val(response.quantity);
            $('#price').val(response.price);
            $('#total').val(response.quantity*response.price);
            calculateTotal();
            }
         });
        }else {
            alert('error loading data');
        }
     }