Create Viewer with Inner Join

Posted by savoine on 11-Feb-2015 03:45

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.

All Replies

Posted by James Palmer on 11-Feb-2015 04:26

Don't quote me on this, but I believe it is the hyphen (-) in the table/field names. You need to quote them IIRC.

This thread is closed