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

[sabrown]

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

[Ben]

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