select recid,(select substr(t.content,1,20) from HQBIS_LEAVEWORD t where t.recid= t2.recid) as content,title,senddate,username,company,address,tel
from HQBIS_LEAVEWORD t2
select recid,(select substr(t.content,1,20) from HQBIS_LEAVEWORD t where t.recid= t2.recid) as content,title,senddate,username,company,address,tel from HQBIS_LEAVEWORD t2