Is it possible to change this query to have blanks instead of .NULL. values:
Or may be even a better way to accomplish this, what I am trying to do is to add four fields(ends,imbc,ord,csz) from table2 to table1 on unirec key and I need to have blanks instead of .NULL.
Code:
Select t1.*, t2.ends, t2.imbc, t2.ord, t2.csz;
from table1 t1 ;
left Join table2 t2 ;
on t1.unirec=t2.unirec ;
into Table currentfile2.dbf
Or may be even a better way to accomplish this, what I am trying to do is to add four fields(ends,imbc,ord,csz) from table2 to table1 on unirec key and I need to have blanks instead of .NULL.