Below is sample SQL showing how we can use additional columns from another table based on value of base table. SELECT base_table.id,...

There are many situations where you need to join same table, but must have different names (you can define this as alias). Below is a simpl...

Hibernate/grails left join or inner join or join when using create criteria. If you do not use 'CriteriaSpecification . LEFT_JOIN ...