I'm trying to create a viewer
CREATE VIEW v_teste (cod_emitente, it_codigo) AS SELECT ped-venda.cod-emitente, ped-item.it-codigo FROM ped-venda INNER JOIN ped-item ON (ped-item.nome-abrev = ped-venda.nome-abrev AND ped-item.nr-pedcli = ped-venda.nr-pedcli)
Displays the following message:
** Table è does not exist or cannot be accessed. (962)
** Nao entendi a linha 1. (196)
If you remove the INNER JOIN does not display the error message.
Sorry for the bad english.
Don't quote me on this, but I believe it is the hyphen (-) in the table/field names. You need to quote them IIRC.