Advertisement
Guest User

Untitled

a guest
Jan 14th, 2020
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 0.36 KB | None | 0 0
  1.    Form1.Query4.SQL.Add('SELECT sotr.fio_sotr, sotr.add_sotr, sotr.tel , sotr.doljn, COUNT(*)');
  2.    Form1.Query4.SQL.Add('FROM protocol, sotr');
  3.    Form1.Query4.SQL.Add('WHERE protocol.kod_sotr = sotr.kod_sotr and Date_vidachi >= "01.01.2013" and Date_vidachi <= "31.12.2013"');
  4.    Form1.Query1.SQL.Add('GROUP BY sotr.fio_sotr, sotr.add_sotr, sotr.tel , sotr.doljn');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement