Код: Выделить всё
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 ('' = ''))
[Тема перещена из раздела "Проектирование БД и запросов"]