outer join mysql
Publicado por Amy (2 intervenciones) el 12/05/2008 22:05:07
Hola:
He intentado ejectura esta sentencia en mysql utilizando el outer join, pero no se porque me causa este error: Unknown column 'art.cveentsap' in 'on clause' . Mi sentencia es:
Select nomentart,nomentsec,nomentapa,IFNULL(nomentsap,' '),nomenttem,diaart,mesart,anoart,nomentpais,nomorgart,nomautart,plbcveart,urldocart
from tblentartl as art,tblentsec as sec,tblentapa as apa,tblentpais as pais LEFT JOIN tblentsap as sap ON (sap.cveentsap=art.cveentsap) LEFT JOIN tblenttem as tem ON (tem.cveenttem=art.cveenttem) and cveentart=70934 and art.cveentsec=sec.cveentsec and art.cveentapa=apa.cveentapa and art.cveartpai=pais.cveentpais
Agradeceria mucho que alguien me pudiese ayudar. Gracias!!
He intentado ejectura esta sentencia en mysql utilizando el outer join, pero no se porque me causa este error: Unknown column 'art.cveentsap' in 'on clause' . Mi sentencia es:
Select nomentart,nomentsec,nomentapa,IFNULL(nomentsap,' '),nomenttem,diaart,mesart,anoart,nomentpais,nomorgart,nomautart,plbcveart,urldocart
from tblentartl as art,tblentsec as sec,tblentapa as apa,tblentpais as pais LEFT JOIN tblentsap as sap ON (sap.cveentsap=art.cveentsap) LEFT JOIN tblenttem as tem ON (tem.cveenttem=art.cveenttem) and cveentart=70934 and art.cveentsec=sec.cveentsec and art.cveentapa=apa.cveentapa and art.cveartpai=pais.cveentpais
Agradeceria mucho que alguien me pudiese ayudar. Gracias!!
Valora esta pregunta
0