You want to see the weekly delivery report. Write a query to output all customers and their orders in one table (fullname - age

Question

Help!!!!

Answer 1

SELECT customers.fullName, Customers.age,Customers.address, Orders.Amount
FROM customers LEFT OUTER JOIN orders
ON customers.ID=Orders.Customerid;

Answer 2

You want to see the weekly delivery report. Write a query to output all customers and their orders in one table (fullname - age - address - amount).

Answer 3

Consider using SELECT INTO, and the YEARWEEK function, something like this:

SELECT fullname, age, address, amount INTO <new table name>
FROM <source query/view/table/join>
WHERE YEARWEEK(<source date column>) = YEARWEEK(Now())