🚀 go-pugleaf

[Delphi 1.02]

I would like to use the result from a first query, e.g.

      procedure TForm1.Button1Click(Sender: TObject);
      begin
      with Query1 do
        begin
        Close;
        SQL.Clear;
        SQL.Add('select * from "MYTABLE.DB" mt');
        SQL.Add('where mt.amount > 100');
        Open;
        end;
      end;

in a subsequent second query. But how can I use the resulting
dataset in this second query?? I tried the following:

      procedure TForm1.Button2Click(Sender: TObject);
      begin
      with Query2 do
        begin
        Close;
        SQL.clear;
        SQL.add('select count(Code) as c1 from wwQuery1');
        Open;

        showmessage(FieldByName('c1').AsString);
        end;
      end;

but this didn't work... How can I access the result of the
first query from within the SQL statement of a second query???

Thanks for any help!

Thomas