Re: [GENERAL] How to get joins to work

2006-11-04 Thread Anonymous
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

Re: [GENERAL] How to get joins to work

2006-11-04 Thread Michael Glaesemann
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

Re: [GENERAL] How to get joins to work

2006-10-24 Thread Martijn van Oosterhout
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

Re: [GENERAL] How to get joins to work

2006-10-24 Thread Michael Glaesemann
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