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
tasks.Contact_id AS Contact_id,
contacts.Id AS Id
/sugarcrm5 on 192.168.2.109/tasks,
/sugarcrm5 on 192.168.2.109/contacts
((tasks.Contact_id='e230674e-2d11-37e9-2974-44a548fc3266') AND (contacts.Id='e230674e-2d11-37e9-2974-44a548fc3266'))
Any help appreciated.