■テストデータ
※ここからは以下のデータを使っています。

●テーブル１　商品テーブル

CREATE TABLE cm_item
(
  code integer NOT NULL,
  name character varying(30) NOT NULL,
  price numeric(9,0) NOT NULL,
  group_code integer NOT NULL,
  group_name character varying(30) NOT NULL,
  CONSTRAINT cm_item_key PRIMARY KEY (code)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE cm_item
  OWNER TO testuser;

●テーブル２　売上データ

CREATE TABLE ms_sales
(
  id serial NOT NULL,
  date date NOT NULL,
  code integer NOT NULL,
  quantity numeric(9,0) NOT NULL,
  price numeric(9,0) NOT NULL,
  money numeric(11,0) NOT NULL,
  CONSTRAINT ms_sales_key PRIMARY KEY (id),
  CONSTRAINT ms_sales_code FOREIGN KEY (code)
      REFERENCES cm_item (code) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE ms_sales
  OWNER TO testuser;

●テストデータ

INSERT INTO cm_item(code, name, price, group_code, group_name)
    VALUES (1, 'オレンジジュース', 100, 1, 'ジュース');
INSERT INTO cm_item(code, name, price, group_code, group_name)
    VALUES (2, '生ジュース', 120, 1, 'ジュース');
INSERT INTO cm_item(code, name, price, group_code, group_name)
    VALUES (3, '板チョコ', 120, 2, 'チョコ');
INSERT INTO cm_item(code, name, price, group_code, group_name)
    VALUES (4, 'コインチョコ', 10, 2, 'チョコ');
INSERT INTO cm_item(code, name, price, group_code, group_name)
    VALUES (5, 'ガム', 80, 3, 'ガム');
INSERT INTO cm_item(code, name, price, group_code, group_name)
    VALUES (6, 'グミ', 110, 4, 'グミ');

●テストデータ

INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 1, 1, 100, 100);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 1, 2, 100, 200);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 2, 1, 120, 120);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 2, 2, 130, 260);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 3, 3, 120, 360);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 3, 1, 120, 120);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 4, 2, 10, 20);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-01', 5, 3, 80, 240);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-02', 5, 1, 80, 80);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-02', 6, 2, 110, 220);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-02', 1, 3, 100, 300);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-02', 2, 4, 110, 440);
INSERT INTO ms_sales(date, code, quantity, price, money)
    VALUES ( '2014-06-03', 3, 5, 80, 400);