edward_hall76 (4/23/2013)
I get this error Operand data type text is invalid for add operatorthe PhoneNumber is in the Names table and the sms is in the Carriers table
Okay, now we need to see the DDL (CREATE TABLE statements) for the tables. I'm not sure which column is what data type. Looks like you will need to cast one or both to a varchar data type.