Hi everybody,

This query gives me the error 'Unrecognized command/keyword' but I don't see whay may be wrong here

           SELECT ALLTRIM(T1.Value_Name) + ', ' + ALLTRIM(T2.Value_Name) as Descrip ;
		   FROM (SELECT tmpl.Value_name, tmpl.hidden, tmpl.atname_id ;
		   FROM i_tmplat tmpl ;
		   INNER JOIN i_tmpnam tmp ON tmpl.tmpnam_id = tmp.tmpnam_id AND tmpl.atname_id = tmp.prim_axis ;
		   WHERE tmpl.tmpnam_id = m.lnTmpl_ID) T1 ;
		   CROSS JOIN i_tmplat T2 WHERE T2.tmpnam_id = m.lnTmpl_ID AND T1.hidden = .f. ;
		   AND T2.hidden = .f. AND T2.atname_id <> T1.atname_id INTO CURSOR csrTmplInfo

Thanks in advance.

UPDATE. Replacing CROSS JOIN with just a comma fixed the problem.