On Nov 4, 2006, at 5:44 , Anonymous wrote:
Please note that natural joins may be dangerous in production code.
See
the following thread for more detailed information...
http://forums.oracle.com/forums/thread.jspa?threadID=440287
All that thread shows is that people are using natural join w
Please note that natural joins may be dangerous in production code. See
the following thread for more detailed information...
http://forums.oracle.com/forums/thread.jspa?threadID=440287
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Oct 25, 2006, at 6:43 , Bill Ewing wrote:
The above two tables are linked. But, none of the following SQL
worked:
select * FROM rack r JOIN sample s
select * FROM rack r INNER JOIN sample s
In each case I get a message "ERROR: syntax error at end of input
at character X" where X
On Tue, Oct 24, 2006 at 02:43:07PM -0700, Bill Ewing wrote:
> I am having trouble getting joins to work. In a Java app that uses Hibernate
> 3.1, I am able to build queries that join two, three or more tables using
> combinations of INNER JOIN, LEFT JOIN or RIGHT JOIN. But, I need FULL OUTER
I am having trouble getting joins to work. In a Java app that uses Hibernate 3.1, I am able to build queries that join two, three or more tables using combinations of INNER JOIN, LEFT JOIN or RIGHT JOIN. But, I need FULL OUTER JOIN to work and have not been able to get them to work in Hibernate.