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: "Alex Blaj" <email@hidden>
- Date: Wed, 20 Aug 2003 11:21:49 +0300
Hi Pierre,
I think the code you wrote might be of help. I'd appreciate if you could
send it to me. Can you send as well the query you obtained using those
qualifiers? I'll check on it and if it doesn't help I'll describe what I'm
trying to get, maybe you can give any further hints.
Thanks alot,
Alex.
----- Original Message -----
From: "Pierre Bernard" <email@hidden>
To: "Alex Blaj" <email@hidden>; <email@hidden>
Sent: Wednesday, August 20, 2003 11:15 AM
Subject: RE: 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
===================================================================Disclaime
r
:
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
**********************************************************************
=====================================================================
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.