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