both column data type must be same

both colmun data type need not be same

one of the data type must be different

both column data type and length must be same