joins

[George Parkinson]

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

On 07 Feb 2011, at 23:47, George Parkinson wrote:

> hello,
> i'm new to valentina (and sql) and am really liking valentina!
> 
> i am having a problem doing joins.
> 
> using the db created from the api_link_binary_records example (vb6),i have 
> 'person' and 'phone' tables with a binarylink 'link_person_phone'.
> 
> as expected, the following statement is good in studio/studio pro :
> SELECT Person.FirstName, Phones.Number FROM Person INNER JOIN Phones ON 
> link_person_phone 
> 
> 
> i then create a 'widget' table, which is basically the same as the phone 
table.
> 
> so the following statement is also good in studio/studio pro :
> SELECT Person.FirstName, Widgets.WidgetDesc FROM Person INNER JOIN Widgets ON 
> link_person_widget 
> 
> 
> so far, each link is functioning as expected....
> but when i try to do the following, 
> 
> SELECT Person.FirstName, Phones.Number, Widgets.WidgetDesc
> FROM    Person INNER JOIN Phones ON link_person_phone 
>    Person INNER JOIN Widgets ON link_person_widget 
> 
> i get a 'kernel error: 0x53502. out of memory'
> 
> i've also tried doing the same with foreign keys, but got the same result.
> 
> i'm stumped...can anyone point me in the right direction?
> 
> thanks,
> george
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

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