the following code would include: select customer t.customerid, order t.customerid, customername, orderid from customer t inner join order t on customer t.customerid