posted 12 years ago
pb sql . no jpa
The INNER JOIN keyword return rows when there is at least one match in both tables.
1. select :
because root query == Employee e. ==>in database:e1[inner d1 OK ],e2[inner d1 OK ],e3[inner d2 OK ],e4[inner d2 OK ] . so result d1,d1,d2,d2 ( because select ==d)
2. select :
because root query == Employee d. ==>in database:d1[inner e1 or e2 OK], d2[inner e3 or e4 OK]. so result d1,d2 ( because select ==d)