SELECT T2.CustNo,
       T4.Company,
       T3.Description, 
       T1.OrderNo, 
       T3.ListPrice, 
       T3.Cost,
       T1.Qty,
       T1.Qty*T3.Cost as Sales 
FROM   "Items.db" T1,
       "Orders.db" T2, 
       "Parts.db" T3, 
       "Customer.db" T4
WHERE  (T2.OrderNo = T1.OrderNo) AND 
       (T3.PartNo = T1.PartNo) AND 
       (T4.CustNo = T2.CustNo) AND
       (T4.CustNo <= 1351)
ORDER BY T2.CustNo, T3.Description

unit SubTotal1Unit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, plPrev, plQueryPrev, DB, DBTables;

type
  TForm1 = class(TForm)
    Query1: TQuery;
    plQueryPrev1: TplQueryPrev;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
  private
    { Private 宣言 }
  public
    { Public 宣言 }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

//=============================================================================
//  クエリの結果を印刷
//  コードはこれだけ．後はオブジェクト・インスペクタで設定
//=============================================================================
procedure TForm1.Button1Click(Sender: TObject);
begin
  plQueryPrev1.Title := 'Queryの印刷例';
  plQueryPrev1.Preview;
end;

end.