TEXT TO lccmd noshow SELECT TOP 100 PERCENT dbo.patients.lastname, dbo.patients.firstname, dbo.meetings.begintime, dbo.meetings.endtime, dbo.meetproc.description, dbo.meetproc.surgeon FROM dbo.patients INNER JOIN dbo.meetings ON dbo.patients.patientid = dbo.meetings.patientid INNER JOIN dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber ORDER BY dbo.patients.lastname, dbo.patients.firstname, dbo.meetings.begintime ENDTEXT SQLEXEC(gnConnHandle,lcCmd,"Cursql") SELECT cursql lnResults=CURSORTOXML('cursql','c:\query1.xml',1,2,0,"")Thanks