pogoj: SELECT TOP 100 type.typnatcode, type.typname, type.typhp, type.typvehtype, type.typimpend, type.typtypbastypeCD, make.maknatcode, make.makname2, price.prinatcode, price.prinp1 FROM make, price, type WITH (NOLOCK) WHERE make.maknatcode=type.typmakCD AND price.prinatcode = type.typnatcode AND type.typvehtype = 10 AND make.makvehtype = 10 AND type.typimpend IS NULL AND type.typtypbastypeCD = 'C40' ORDER BY type.typModCd, price.prinp1