hi again hilmar!

i'm up a blind alley. i'm trying to use the copy to mytext.txt type delimited to realize i need to get data from 3 tables.

my main table has the fields empno and comid. empno is in table employee, and comid is in table comments.

so i try to use this sql statement,

select a.status, a.empno, prop(allt(b.lastname)+", "+allt(b.firstname)+iif(!empty(b.mid)," "+b.mid+".","")), a.signoutdate, a.signout, a.signindate, a.signin, c.comments ;
from inout a, employee b, comments c where b.empno=a.empno and c.comid=a.comid ;
order by a.signoutdate desc, a.signout desc, a.signin ;
to file mytext

however, i noticed i'm getting more than one field name in the text, like this

STATUS              EMPNO                  EMPNAME
.T.                 00000                  LENNON, JOHN
.T.                 00001                  MCCARTNEY, PAUL
STATUS              EMPNO                  EMPNAME
.F.                 00002                  STARR, RINGO
.F.                 00003                  HARISON, GEORGE

why is that? how can i avoid this? or is there any way to do this?

pls advice. TIA.