Return-Path: 
 <torque-user-return-6177-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 93615 invoked from network); 10 Jun 2005 13:23:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 10 Jun 2005 13:23:18 -0000
Received: (qmail 26878 invoked by uid 500); 10 Jun 2005 13:20:15 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 26823 invoked by uid 500); 10 Jun 2005 13:20:13 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 26766 invoked by uid 99); 10 Jun 2005 13:20:12 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from mail05.allianz.de (HELO mail05.allianz.de) (194.127.3.25)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 10 Jun 2005 06:20:09 -0700
Received: from mail04.allianz.de (rmx0324.muc.allianz [192.168.5.24])
	by mail05.allianz.de  with ESMTP id j5A91bno007579
	for <torque-user@db.apache.org>; Fri, 10 Jun 2005 11:01:37 +0200 (MEST)
Received: from rmx3606.muc.allianz ([194.127.36.6])
	by mail04.allianz.de  with ESMTP id j5A91Q59028624
	for <torque-user@db.apache.org>; Fri, 10 Jun 2005 11:01:27 +0200 (MEST)
Received: from dblmxs1.dresdner-bank.lu ([171.25.98.6])
	by rmx3606.muc.allianz (Switch-3.1.7/Switch-3.1.7) with ESMTP id
 j5A91Prh000156
	for <torque-user@db.apache.org>; Fri, 10 Jun 2005 09:01:26 GMT
Received: by dblmxs1 with Internet Mail Service (5.5.2653.19)
	id <M4P9B182>; Fri, 10 Jun 2005 11:00:56 +0200
Message-ID: <4A2E265BA43ED5408940E6C0815899EB03B5097B@DBLMXS3>
From: "Dressler,Erik(externe MA)" <Erik.Dressler@Dresdner-Bank.lu>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Subject: criteria-problem
Date: Fri, 10 Jun 2005 11:02:04 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


hello, everybody!

is it possible to create a criteria for the statement below???

SELECT p.statecode AS Vater, s.statecode AS Nachfolger
FROM processstate p, processstate s
WHERE s.lft BETWEEN p.lft AND p.rgt
AND s.statecode = 'D225'
ORDER BY p.lft;

i have problems to assign one table two aliases and to select the same
column twice with two different aliases!!!

i'm completely mystified!!!!

greetz, erik
 
*  *  *  *  *  *  D I S C L A I M E R  *  *  *  *  *  *  *
 
This message is confidential and intended for the named addressee(s) only.
If you are not the intended recipient, please contact the sender by E-Mail
return and then delete this message from your system. You should not copy
or use it or disclose its contents to any other person.
 
If any part of this message is illegible or if you suspect that the message
may have been intercepted or amended, please contact the sender.
Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
accuracy or completeness of this message without further investigation.
 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org