RE: how to generate multiple aliases in a SELECT
RE: how to generate multiple aliases in a SELECT
- Subject: RE: how to generate multiple aliases in a SELECT
- From: "Pierre Bernard" <email@hidden>
- Date: Wed, 20 Aug 2003 10:15:41 +0200
- Thread-topic: how to generate multiple aliases in a SELECT
Hi!
You could probably achieve the desired result by creating your own qualifier.
I just finished implementing two qualifiers which are used to qualify on tables where entries have an 'effect date'. The only valid entry is the one with the highest effect date below a given limit for a given parent.
These qualifiers work by nesting several SELECT statements.
If you think this might be of some help to you, I could mail you the code for those.
Pierre.
--
Got a hang for movies?
http://homepage.mac.com/I_love_my/movies.html
-----Original Message-----
From: Alex Blaj [mailto:email@hidden]
Sent: Wednesday, August 20, 2003 9:54 AM
To: email@hidden
Subject: how to generate multiple aliases in a SELECT
Hi there,
I need to create a fetchSpecification that would generate a SELECT statement
like this:
"SELECT T1.PK FROM TABLE1 T1, TABLE2 T2, TABLE2 T3 WHERE
T1.PK = T2.TABLE1_ID AND T2.PK = 1 AND
T1.PK = T3.TABLE1_ID AND T3.PK = 2;"
The difficult thing is to create 2 qualifiers for this fetchSpecification that
would generate the "FROM TABLE2 T2, TABLE2 T3" (2 aliases for the same table
TABLE2).
Everything I tried so far led me to a single alias to TABLE2 in the FROM
part.
Or, if there is anyone specialized in FrontBase (or some other database
support which supports "(SELECT ... ) INTERSECT (SELECT ...);"), could you
tell me how to implement the INTERSECT into my fetchSpecifiction?
I'm using WO 5.2 with FrontBase.
Any hint would be highly appreciated.
Alex.
===================================================================Lettrix bv,
P.O. Box 5, 6980 AA Doesburg,
The Netherlands -- Tel: +31 313 478 000,
Fax: +31 313 478 080 -- Check our website at:
http://www.lettrix.com
===================================================================Disclaimer
:
The information contained in this communication is confidential and
may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful. Lettrix B.V. is neither liable for
the proper and complete transmission of the information contained in
this communication nor for any delay in its receipt.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
**********************************************************************
This email and any files transmitted with it are intended solely for
the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender
of this message. (email@hidden)
This email message has been checked for the presence of computer
viruses; however this protection does not ensure this message is
virus free.
Banque centrale du Luxembourg; Tel ++352-4774-1; http://www.bcl.lu
**********************************************************************
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.