I get an error on the following query: SELECT egw_pm_projects.pm_id AS pm_id, pm_number, pm_title, role_acl, egw_pm_projects.pm_id AS pm_id FROM egw_pm_projects LEFT JOIN egw_pm_members ON (egw_pm_projects.pm_id=egw_pm_members.pm_id AND member_uid=7) LEFT JOIN egw_pm_roles ON egw_pm_members.role_id=egw_pm_roles.role_id WHERE (pm_access='anonym' OR pm_access='public' AND pm_creator IN (7) OR pm_access='private' AND pm_creator IN (7) OR egw_pm_roles.role_acl!=0) AND (pm_status='template') ORDER BY pm_number
maxdb Error: S1000 ([unixODBC][SAP AG][LIBSQLOD SO][MaxDB] General error;-7068 POS(206) Outer join not allowed in this context) These are the schemas: Table "DBADMIN.EGW_PM_PROJECTS" | Column Name | Type | Length | Nullable | KEYPOS | | ------------------ | ------------- | ------ | -------- | ------ | | PM_ID | INTEGER | 10 | NO | 1 | | PM_NUMBER | VARCHAR ASCII | 64 | NO | | | PM_TITLE | VARCHAR ASCII | 255 | NO | | | PM_DESCRIPTION | LONG ASCII | - | YES | | | PM_CREATOR | INTEGER | 10 | NO | | | PM_CREATED | FIXED | 20 | NO | | | PM_MODIFIER | INTEGER | 10 | YES | | | PM_MODIFIED | FIXED | 20 | YES | | | PM_PLANNED_START | FIXED | 20 | YES | | | PM_PLANNED_END | FIXED | 20 | YES | | | PM_REAL_START | FIXED | 20 | YES | | | PM_REAL_END | FIXED | 20 | YES | | | CAT_ID | INTEGER | 10 | YES | | | PM_ACCESS | VARCHAR ASCII | 7 | YES | | | PM_PRIORITY | SMALLINT | 5 | YES | | | PM_STATUS | VARCHAR ASCII | 9 | YES | | | PM_COMPLETION | SMALLINT | 5 | YES | | | PM_USED_TIME | INTEGER | 10 | YES | | | PM_PLANNED_TIME | INTEGER | 10 | YES | | | PM_USED_BUDGET | FIXED | 20,2 | YES | | | PM_PLANNED_BUDGET | FIXED | 20,2 | YES | | | PM_USED_BUDGET | FIXED | 20,2 | YES | | | PM_PLANNED_BUDGET | FIXED | 20,2 | YES | | | PM_OVERWRITE | INTEGER | 10 | YES | | | PM_ACCOUNTING_TYPE | VARCHAR ASCII | 10 | YES | | Table "DBADMIN.EGW_PM_MEMBERS" | Column Name | Type | Length | Nullable | KEYPOS | | ------------------- | -------- | ------ | -------- | ------ | | PM_ID | INTEGER | 10 | NO | 1 | | MEMBER_UID | INTEGER | 10 | NO | 2 | | ROLE_ID | INTEGER | 10 | YES | | | MEMBER_AVAILIBILITY | FLOAT | 38 | YES | | Table "DBADMIN.EGW_PM_ROLES" | Column Name | Type | Length | Nullable | KEYPOS | | ---------------- | ------------- | ------ | -------- | ------ | | ROLE_ID | INTEGER | 10 | NO | 1 | | PM_ID | INTEGER | 10 | YES | | | ROLE_TITLE | VARCHAR ASCII | 80 | NO | | | ROLE_DESCRIPTION | VARCHAR ASCII | 255 | YES | | | ROLE_ACL | INTEGER | 10 | NO | | Thanks for your help :-) Ralf -- Ralf Becker eGroupWare Training & Support ==> http://www.egroupware-support.de Outdoor Unlimited Training GmbH [www.outdoor-training.de] Handelsregister HRB Kaiserslautern 3587 Geschäftsführer Birgit und Ralf Becker Leibnizstr. 17, 67663 Kaiserslautern, Germany Telefon +49 (0)631 31657-0 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
