JOIN

CREATE VIEW [dbo].[SalesView]

     AS SELECT  orderTBL.Id orderID,

          productTBL.name productName,

          salesTBL.amount ,

          productTBL.price productPrice,

          customerTBL.fullname customerName,

          customerTBL.address address,

          orderTBL.date orderDate FROM (((salesTBL

          INNER JOIN productTBL ON salesTBL.productID = productTBL.Id )

          INNER JOIN orderTBL ON salesTBL.orderID = orderTBL.Id)

          INNER JOIN customerTBL ON orderTBL.custID = customerTBL.Id)