left join

select t1.rdate, t1.aseq, t1.bst1, t1.bst2, t1.bst3, t1.bst4, t1.bst5, t1.capa, t1.position,
t1.aseqrdate, t1.eseq, t2.bp, t3.esign as sign
from TBSTRecord as t1 left join TAngelHealthStatus as t2 on t1.aseq = t2.aseq
left join TEmployee as t3 on t1.eseq=t3.seq
where t1.aseq='86' and date_format(t1.rdate, '%Y-%m-%d')
between date_format('2012-07-01', '%Y-%m-%d') and date_format('2012-07-31', '%Y-%m-%d') order by t1.rdate desc