I'm having problems reporting with a join file. All is ok if this is used-:
TABLE FILE &ROC
PRINT *

But outputting specific fields like this-:

TABLE FILE &ROC
PRINT &ROC|.POLICY, &ROC|.STAT, &ROC|.UPD_DAYS, FNET.FNET_DATE

then reports the following error-:

1
0 NUMBER OF RECORDS IN TABLE= 3524 LINES= 3524
0
(FOC441) WARNING. THE FILE EXISTS ALREADY. CREATE WILL WRITE OVER IT
0 ERROR AT OR NEAR LINE 305 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: GL93.POLICY,
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
---------------------------------------------
======================================
Init stuff is
APP DISABLE
-SET &FILEDIR = D:\WEBFOCUS\APPS\ET;
FILEDEF HOLDMAST DIR &FILEDIR
-RUN
======================================


USE
&FILEDIR|\&ROC|.FOC NEW
END

TABLE FILE T3
PRINT *
ON TABLE HOLD AS &ROC FORMAT FOCUS INDEX POLICY
END
-RUN

USE
&FILEDIR|\&ROC|.FOC
&FILEDIR|\FNET.FOC
END

JOIN POLICY IN &ROC TO ALL POLICY IN FNET AS J1

USE
&FILEDIR|\&ROC|.FOC
&FILEDIR|\FNET.FOC
END

TABLE FILE &ROC
PRINT &ROC|.POLICY, &ROC|.STAT, &ROC|.UPD_DAYS, FNET.FNET_DATE
END
-RUN

DaveS,
To stop getting error FOC003 you will need to remove the comma.

This will get error FOC003:
TABLE FILE CAR
PRINT RETAIL_COST, DEALER_COST, COUNTRY, CAR
END

This will not get error FOC003:
TABLE FILE CAR
PRINT RETAIL_COST DEALER_COST COUNTRY CAR
END

Thanks that worked perfectly.