May I suggest something that helps me?
I format my SQL field syntax in pseudo-columns. Yes, it looks strange at first but one gets used to it and the compiler doesn't care. These syntax errors become much easier to spot.
SELECT x.ssno ;
, x.firstname ;
x.lastname ;
, x.idnumber ;
, y.idnumber ;
, y.imageid ;
FROM ud_tbl x ;
INNER JOIN it_tbl y ON x.idnumber = y.idnumber ;
INTO CURSOR test