iBase.ru Forum

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

SELECT
  o.id_obj,
  o.KN_obj,
  alladr.FULLATDNAME,         
  ap.name_prf,
  an.num1_asnum
FROM OBJ o
   INNER JOIN OBJLOT ol ON (o.ID_OBJ = ol.ID_OBJ)
   INNER JOIN ASNUM an ON (an.ID_asnum = Ol.ID_asnum)
   INNER JOIN ASPRF ap ON (an.ID_prf = ap.ID_prf)
   left JOIN GETFULLATD(ap.id_ATD) ALLAdr ON (1=1)
WHERE
   ((alladr.FULLATDNAME like '') or ('' = '')) and
   ((ap.name_prf like '') or ('' = '')) and
   ((an.num1_asnum like '') or ('' = ''))