Forum Post: Create Viewer with Inner Join

  • Thread starter Thread starter savoine
  • Start date Start date
Status
Not open for further replies.
S

savoine

Guest
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.

Continue reading...
 
Status
Not open for further replies.
Back
Top