i supposed to concatenate areacode and phone number field and have this inner joined with other table but it only gave me the phone data. I used open query syntax .. select areacode+phone from openquery (dbname,'select * from table where campain="x"')
From the openquery you're showing, you're doing a SELECT *. If you're not getting areacode, that must be because it's not filled out in that table. If the column itself was missing, you'd get an error.