Форум программистов [Powered by Invision Power Board]

Код

SELECT   Data.Cod_Ent, Data.Enterprises, Rubrica_Ref.Rubrica, SubRubrica_Ref.SubRubrica, 
                SubSubRubrica_Ref.SubSubRubrica, 
                Region.Region + ' ' + Region.Short_Reg + ', ' + Rajon.Rajon + ' ' + Rajon.Short_Rajon + ', ' + NP.Short_NP + '. ' + NP.NP
                 + ', ' + Street.Short_Street + '. ' + Street.Street + ', строение ' + Building.Build AS addrr, Ext_Info.ExtInfo
FROM      (((((Region INNER JOIN
                (Rajon INNER JOIN
                ((Building INNER JOIN
                (Street INNER JOIN
                NP ON Street.Cod_NP = NP.Cod_NP) ON Building.Cod_Street = Street.Cod_Street) INNER JOIN
                Data ON Building.Cod_Adres = Data.Cod_Adres) ON Rajon.Cod_Rajon = NP.Cod_Rajon) ON 
                Region.Cod_Region = Rajon.Cod_Region) INNER JOIN
                Rubrica_Ref ON Data.Cod_Rubrica = Rubrica_Ref.Cod_Rubrica) INNER JOIN
                SubRubrica_Ref ON Data.Cod_SubRubrica = SubRubrica_Ref.Cod_SubRubrica) INNER JOIN
                SubSubRubrica_Ref ON Data.Cod_SubSubRubrica = SubSubRubrica_Ref.Cod_SubSubRubrica) LEFT OUTER JOIN
                Ext_Info ON Data.Cod_Ent = Ext_Info.Cod_Ent)
WHERE   (Data.Enterprises LIKE '%' + ? + '%') AND (NP.NP LIKE '%' + ? + '%') AND (Street.Street LIKE '%' + ? + '%') AND 
                (Building.Build LIKE '%' + ? + '%') AND (Rajon.Rajon LIKE '%' + ? + '%')
ORDER BY Data.Enterprises