qInsertar:= TQuery.create(Application);
with qInsertar do
begin
try
close;
SQL.Clear;
DatabaseName := miBase;
SQL.Add('Insert into '+tabla1+' (Id)');
SQL.Add('Values (:id)');
Prepare;
tabla2.first;
tabla3.first;
while (not tabla2.eof)and(not tabla3.eof) do
begin
if (tabla2.FieldByName('CODIGO').AsInteger=tabla3.FieldByName('CODIGO').AsInteger) and
(tabla2.FieldByName('NOMBRE').AsString=tabla3.FieldByName('NOMBRE').AsString) then
begin
Parambyname('id').AsInteger := tabla2.FieldByName('CODIGO').AsInteger;
ExecSQL;
tabla2.next;
tabla3.next;
end
else
begin
end;
end;
finally
Free;
end;
end;