>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.
Yes, that must be it. I recently learned the CROSS JOIN syntax in an Oracle course; it seems that it isn't supported by Visual FoxPro.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)