Here is my total query....the photo_file field stops after 20 characters. Why? The photo_field is a varchar(200) in the database
CREATE TEMPORARY TABLE temp_union select Id,lister_office_name,photo_file,baths from residential where lister_office_name='Century 21 Highview Realty';
INSERT INTO temp_union select Id,lister_office_name,photo_file,baths_unit AS baths from multi where lister_office_name='Century 21 Highview Realty';
SELECT * FROM temp_union;