Mixing implicit and explicit JOINs

by

It results in an error because according to the SQL standard, the JOIN keyword has higher precedence than the comma. The sticky point is that table aliases are not usable until after the corresponding table has been evaluated in the FROM clause.

So when you reference e1 in your JOIN...ON expression, e1 doesn’t exist yet.

Please stand by while I research Hibernate and find out if you can persuade it to use JOIN in all cases.

Hmm. Everything at Hibernate.org seems to be redirecting to jboss.org. So no way to read HQL documentation online right now. I’m sure they’ll figure out their name serving eventually.

More Related Contents:

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. Explicit vs implicit SQL joins
  3. SQL JOIN and different types of JOINs
  4. CROSS JOIN vs INNER JOIN in SQL
  5. SQL join: selecting the last records in a one-to-many relationship
  6. Does the join order matter in SQL?
  7. SQL Inner-join with 3 tables?
  8. What is the difference between JOIN and UNION?
  9. Filter Table Before Applying Left Join
  10. Left Outer Join Not Working?
  11. Difference between natural join and inner join
  12. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  13. What’s the best way to join on the same table twice?
  14. Inner Join vs Natural Join vs USING clause: are there any advantages?
  15. Including null values in an Apache Spark Join
  16. Call a set-returning function with an array argument multiple times
  17. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  18. MySQL – Selecting data from multiple tables all with same structure but different data
  19. ORA – 00933 confusion with inner join and “as”
  20. MySQL: GROUP_CONCAT with LEFT JOIN
  21. Joining multiple tables in SQL
  22. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  23. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  24. sql sum data from multiple tables
  25. Venn Diagram for Natural Join
  26. SQL query: Simulating an “AND” over several rows instead of sub-querying
  27. Why do multiple-table joins produce duplicate rows?
  28. SQL SELECT from multiple tables
  29. IN vs. JOIN with large rowsets
  30. Redundant data in update statements

Leave a Comment