Devart Forum

Код: Выделить всё

SELECT distinct 
     a.id
     , a.txt
     , a.rub_id
     , a.rub
     , a.vid
     , a.id_obj_site
     , a.id_user_ekr
     , a.Deleted
     , a.paid
     , a.id_team
     , a.gdn
	 , a.rub_code

FROM
  kvartal_prem.ads a
left JOIN datas d
ON (d.id_ads = a.id)

Код: Выделить всё

  with fUniQuery do
  begin
    Close;
    DeleteWhere;
    KeyFields := 'id';

    //если выбрана какая-то бригада(ы)
    if team_list <> '' then
      AddWhere('a.id_team in (' + team_list + ')');

    //активные
    AddWhere('a.Deleted = 0');

    //отключаем ЖиДН (берем только в Премьер)
    AddWhere('a.gdn = 0');

    AddWhere('d.date_out = :dt_out');
    ParamByName('dt_out').AsDate := date_out;

    ShowMessage(SQL.Text);
  end;//with

Код: Выделить всё

SELECT distinct 
     a.id
     , a.txt
     , a.rub_id
     , a.rub
     , a.vid
     , a.id_obj_site
     , a.id_user_ekr
     , a.Deleted
     , a.paid
     , a.id_team
     , a.gdn
	 , a.rub_code

FROM
  kvartal_prem.ads a
left JOIN datas d
ON (d.id_ads = a.id)
WHERE (((a.id_team in (12,11,5,9,328)) AND a.Deleted = 0) AND a.gdn = 0) AND d.date_out = :dt_out 

Код: Выделить всё

WHERE a.id_team in (827,21,17,15) AND a.Deleted = 0 AND a.gdn = 0 AND d.date_out = :dt_out 

Код: Выделить всё

WHERE (a.id_team in (827,21,17,15)) AND (a.Deleted = 0) AND (a.gdn = 0) (AND d.date_out = :dt_out )