[FAQ] Tricky SELECT help request

[Ruslan Zasukhin]

On 4/29/04 9:49 AM, "rinaldi.frederic at free.fr" <rinaldi.frederic at free.fr>
wrote:

> Name:      Fr&#233;d&#233;ric RINALDI
> 
> Question regarding: sql
> 

Hi Rilandi,


> Hi, I'm a licensee of Valentina XCMD.

> I'm currently building an Email base app,

Wow!

For commercial use?

It seems far ago was dream to get emailer based on Valentina.

> where I use a 'Base' table
> containing among others two similar ObjectPtr fields: 'ToPtr' and 'FromPtr',
> both pointing to the same 'Emails' table.

> What is the SELECT syntax to get a list of all 'Base' table records including
> for each both FromEmail and ToEmail datas?

I think you need aliases for tables


    select 
    FROM Base, Emails a, Emails b
    WHERE 
        ToPtr = a.RecId and FromPtr= b.recID
    
    


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------