joins

George Parkinson george at microtherapy.ca
Mon Feb 7 16:47:04 CST 2011


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


More information about the Valentina mailing list