Is there a way to create a M-M Binary Link in VStudio via a
CreateLink dialog?
Ruslan Zasukhin
sunshine at public.kherson.ua
Sun Jul 15 09:35:12 CDT 2007
On 13/7/07 8:07 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:
Hi Barry,
> Hi All,
>
> Assume you have two tables T1 and T2.
> And binary link T1_T2 as M::1.
>
> So
> SELECT * FROM T1 LEFT OUTER JOIN T2
>
> I can¹t seem to get the Valentina Studio v3.1 to build this OUTER JOIN for me
> in the SQL Builder.
RIGHT.
Valentina Studio's Query Builder cannot make OUTER joins.
Actually MS SQL Server also cannot :-)
So this kind of query you need finish manually yet.
We have ideas how to resolve this, but require a lots of improvements of
Query Builder. So not in nearest future.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
More information about the Valentina-studio
mailing list