[Yurk@]

Код:

with Module.Q_PoiskKontragenta do
begin
  Close;
  SQL.Clear;
  SQL.Add('SELECT id_face, adres_id, telefon_id, agency_contract_id, full_name, r_k_o, district, nas_punct, town, streen, doc, korpus, flat, inn, birthday');
  SQL.Add('FROM adres');
  SQL.Add('  JOIN face ON face.adres_id = adres.id_adres');
  SQL.Add('WHERE full_name CONTAINING (:tb)');
  Parameters.ParamByName('tb').Value := tb_Poisk.Text;
end;