Re: Is It Possible Add Joins To QueryByCriteria?

2006-06-23 Thread Danilo Tommasina
or clarities sake - there is no requirement for OJB references to be backed by foreign-key constraints on the database. HTH. Cheers, Charles. -Original Message----- From: Danilo Tommasina [mailto:[EMAIL PROTECTED] Sent: 21 June 2006 08:53 To: OJB Users List Subject: Is It Possible Add

Re: Is It Possible Add Joins To QueryByCriteria?

2006-06-21 Thread Danilo Tommasina
inal Message- From: Danilo Tommasina [mailto:[EMAIL PROTECTED] Sent: 21 June 2006 08:53 To: OJB Users List Subject: Is It Possible Add Joins To QueryByCriteria? Hello, We are having following problem: Table TEMP { attr1, attr2, attr3 } Table A { attr1 (...) } Table B { attr1

RE: Is It Possible Add Joins To QueryByCriteria?

2006-06-21 Thread Charles Anthony
s. -Original Message- From: Danilo Tommasina [mailto:[EMAIL PROTECTED] Sent: 21 June 2006 08:53 To: OJB Users List Subject: Is It Possible Add Joins To QueryByCriteria? Hello, We are having following problem: Table TEMP { attr1, attr2, attr3 } Table A { attr1 (...) } Table B {

Is It Possible Add Joins To QueryByCriteria?

2006-06-21 Thread Danilo Tommasina
Hello, We are having following problem: Table TEMP { attr1, attr2, attr3 } Table A { attr1 (...) } Table B { attr1 (...) } Table C { attr1 (...) } There are no foreign key contraints between TEMP and the A,B,C tables however 'attr1' in all tables refer to the same 'logical obj