Kirix Support Forums

CAnnot seem to access more than two MySQL tables in a query

Please post any help questions, requests or other feedback here.

CAnnot seem to access more than two MySQL tables in a query

Postby sabrown on Sun Mar 22, 2009 2:20 pm

I an trying to query two tables from a SugarCRM 5 database.

First I tried setting up relationships with various join options. Every time I added in a second table, the query would return no rows.

Then I dropped back to explicitly setting the where clause to select each table by a common key. Again, each time I added a second table, the query reverted to returning zero rows.

Here is the SQL generated by Kirix:

Code: Select all
SELECT
    tasks.Contact_id AS Contact_id,
    contacts.Id AS Id
FROM
    /sugarcrm5 on 192.168.2.109/tasks,
    /sugarcrm5 on 192.168.2.109/contacts
WHERE
    ((tasks.Contact_id='e230674e-2d11-37e9-2974-44a548fc3266') AND (contacts.Id='e230674e-2d11-37e9-2974-44a548fc3266'))

Any help appreciated.

--Scott
sabrown
Registered User
 
Posts: 1
Joined: Sun Mar 22, 2009 2:10 pm

Re: CAnnot seem to access more than two MySQL tables in a query

Postby Ben on Mon Mar 23, 2009 4:49 am

Hi Scott,

In the current released version, joins using mounted databases are unfortunately not allowed. This is something we are working on currently. I'd recommend dragging the tables to either the root folder of your project or another folder and then running the join on those tables.

Please let me know how this works for you. If you continue to have problems, let me know and we'll try some other potential solutions

All the best,
Ben
Ben Williams
Kirix Support Team
User avatar
Ben
Kirix Support Team
 
Posts: 522
Joined: Mon Dec 19, 2005 6:29 am

Return to Strata Help & Feedback