• Judging from the error message I would say that the column PREZZI.PRE is missing from the SELECT statement specified for the OPENQUERY.

    Also the "AND PUB.PREZZI.pre-anno = 2012" will indeed give errors: you have to quote the column name when reserved characters are used, like so:

    AND PUB.PREZZI."pre-anno" = 2012