CREATE TABLE CUSTOMER
    (CUSTOMERID NUMBER(5) PRIMARY KEY NOT NULL,
        FNAME VARCHAR2(20),
        LNAME VARCHAR2(20),
        ADDRESS1 VARCHAR2(50),
        TOWNID NUMBER(4),
        DATEJOIN DATE);

CREATE TABLE ORDERS2CUSTOMER
    (ORDERS2CUSTOMERID NUMBER(5) PRIMARY KEY NOT NULL,
        CUSTOMERID NUMBER(5),
        ORDERID NUMBER(2));

CREATE TABLE ORDERS
    (ORDERSID NUMBER(5) PRIMARY KEY NOT NULL,
        DATEOFORDER DATE,
        ORDERCOMPLETE VARCHAR2(1));

CREATE TABLE GARMENT2ORDER
    (GARMENT2ORDERID NUMBER(5) PRIMARY KEY NOT NULL,
        GARMENTID NUMBER(5),
        ORDERID NUMBER(2));

CREATE TABLE GARMENT
    (GARMENTID NUMBER(5) PRIMARY KEY NOT NULL,
        CATALOGUE VARCHAR2(20),
        TYPE VARCHAR2(20),
        COST NUMBER(6, 2));

quote:

---

Originally posted by NeilG

Odd design, but happen this will help you get started

SELECT
C.CustomerID,
G.SUM(COST)
FROM
CUSTOMER C
INNER JOIN ORDERS2CUSTOMERS O2C
ON (C.CustomerID = O2C.CustomerID)
INNER JOIN ORDERS O
ON (O2C.OrderID = O.OrderID)
INNER JOIN GARMENT2ORDER G2O
ON (O.OrderID = G2O.OrderID
INNER JOIN GARMENT G
ON (G2O.GarmentID = G.GarmentID)
WHERE
C.MONTH(DATEJOIN) = [RequiredMonth]
GROUP BY
C.CustomerID

---

WHERE DATEJOIN >= {start date of month}
AND DATEJOIN <{start date of month} +1