joins

[Ruslan Zasukhin]

On 2/8/11 3:06 AM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi Guys,

So we have bug in Query Builder?
Igor please check it


> brilliant!
> being new to this, i assumed the statement created by sql builder in studio
> pro 
> couldn't be the issue...apparently, it was.
> thanks bart,
> george
> 
> 
> 
> 
> 
> ----- Original Message ----
> From: Bart Pietercil <bart.pietercil at cognosis.be>
> To: Valentina Developers <valentina at lists.macserve.net>
> Sent: Mon, February 7, 2011 5:53:48 PM
> Subject: Re: joins
> 
>> SELECT Person.FirstName, Phones.Number, Widgets.WidgetDesc
>> FROM    Person INNER JOIN Phones ON link_person_phone
>>    Person INNER JOIN Widgets ON link_person_widget
> 
> should be
> 
>> SELECT Person.FirstName, Phones.Number, Widgets.WidgetDesc
>> FROM    Person INNER JOIN Phones ON link_person_phone
>>    INNER JOIN Widgets ON link_person_widget
> 
> 
> (removed Person which is already in the tables used in the query)
> 
> untested so  hoping this works for you
> 
> regards
> 
> Bart Pietercil
> CTOCognosis NV

-- 
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]