Java Persistence Query Language JPQL

preview_player
Показать описание
The Java Persistence Query Language JPQL
THIS MATERIAL BEEN TAKEN FROM Java Platform, Enterprise Edition 6 Tutorial at:
Рекомендации по теме
Комментарии
Автор

Hello,
I like to query multiple tables with JPQL ?
I want to show the name, not the id . with SQL I do so :
mysql_query("SELECT campo1, campo2, campo3, campo4, table2.campo,
table3.campo, tabla4.campo
FROM tabla1, tabla2, tabla3, tabla4
WHERE (campotabla1 = tabla2.idcampol) AND (campotabla1= tabla3.idcampo) AND (campotabla1= tabla4.idcampo)")

thank you for your Help !!!

dai
visit shbcf.ru