Left Join on Binary Links

Barry G. Sumpter BarrySum at BigPond.Net.AU
Fri Jul 13 05:58:49 CDT 2007


Excellent!

Thanks for taking the time to reply.



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ivan Smahin
Sent: Friday, 13 July 2007 7:23 PM
To: Valentina Developers
Subject: Re: Left Join on Binary Links

Hello Barry,

Friday, July 13, 2007, 11:58:42 AM, you wrote:

BGS> Hi all,

BGS> I've just setup my first many to one Binary Link.

BGS> I'd like to return a left join result set from my many to one Binary
Link.

BGS> Is it possible?

BGS> If so, then how?

Assume you have two tables T1 and T2.
And binary link T1_T2 as M::1.

So
SELECT * FROM T1 LEFT OUTER JOIN T2



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina



More information about the Valentina mailing list