I am having two tables A and B.Column1 of both the tables are same valuse but in table A it is declared as Integer and NOT NULL.But in table B it is Integer. Now as per the optimized query I want to use the value from column B. But due to this selection, I am getting the output record length as 28. Previously it was 29. Beacuse of this mismatch, all other steps are failing. Is there any way to add one more byte in the select statement?