Meaningless Drivel is fun!*
The moose likes EJB Certification (SCBCD/OCPJBCD) and the fly likes Select ... from ... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Certification » EJB Certification (SCBCD/OCPJBCD)
Bookmark "Select ... from ..." Watch "Select ... from ..." New topic
Author

Select ... from ...

Tang Yue
Ranch Hand

Joined: Nov 11, 2008
Posts: 40
If select x from X x, Y y
The comma in the "from" clause is equivalent to an Inner Join or a pure Cartesian join?

In ETS test 5 Q.62:
Consider the following JPQL:

select c from Customer c, IN(c.orders) o

What will this query return?


The correct answer is :
All Customers who have at least one Order.

Because the query is translated into
"For Sun Java Application Server and MySQL, select c from Customer c, IN(c.orders) o actually gets translated to :
SELECT DISTINCT t0.ID, t0.LASTNAME FROM CUSTOMER t0, ORDER t1 WHERE (t1.CUSTOMER_ID = t0.ID)
"

But in EJB in action, the book says one can perform theta join using ',' in the "from" clause.

I am totally confused.


Houston Rockets go go go!
Chaminda Amarasinghe
Ranch Hand

Joined: May 17, 2006
Posts: 402
I think the book does not say that...

See this example

SELECT i
FROM Item i, Category c
WHERE i.star = c.rating

the relationship has been made using where not by ','

Anyway enthus answer is correct according to experience and spec.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Select ... from ...