Use SQL Select to create one result from the three tables.

Output options:
COPY TO command, look at delimited with TAB option.

If you need more control, do a SCAN/ENDSCAN, and create an output string as you go through the records. See STRTOFILE() command to output the string to a text file.

>Hi
> I have data in three different tables that are related to each other via normalization(3 dbf tables). I want to create a text file(in notepad) exporting data from these tables to the text file. In doing so I want to control the position on the notepad where I want to drop the data. Which function or functions is good for this. Please guide.
>
>Thanks
>Bharat