In join sample program, what do we mean by the line?
String sql_query = "from Product p inner join p.dealer as d";
what does it mean? Product p inner join p.dealer as d
The query is incomplete.
Here is a complete query:
String sql_query = "select d.name,p.name,sum(p.price) as totalprice from Product p join p.dealer d group by p.name";
For more information, visit the following link:
The query you have given was the plain old sql query, the query i have given was HQL query. **Product p inner join p.dealer as d** what is the meaning of the above line