M
MNJoe
I am having problems with an outer join in a query. Not sure where it is
coming from. What I have is a SQLBase server made by Unify company. I am
trying to make an Access 2003 report. 2 tables Purchase_Order and
Purc_Order_Line. There are times when the purchasing dept starts a purchase
order but never puts any lines in. I would like to be able to report these
headers. I make the Join in the SQL statement a outer join where the table
Purchase_Order has records and the Purc_Order_Line table may not. I get the
error
ODBC Call Fail
[Gupta][ODBC Driver]][Parseer][Position (39,92)] 'Outer Join' Key word is
missing (3-19)
I ran the ODBC trace and contacted Unify and my contact there said that it
is producing a strange SQLStatement. It is
"SELECT
"SYSADM"."PURCHASE_ORDER"."ID","SYSADM"."PURC_ORDER_LINE"."PURC_ORDER_ID","SYSADM"."PURC_ORDER_LINE"."LINE_NO"
FROM {oj "SYSADM"."PURCHASE_ORDER" LEFT OUTER JOIN "SYSADM"."PURC_ORDER_LINE"
ON ("SYSADM"."PURCHASE_ORDER"."ID" =
"SYSADM"."PURC_ORDER_LINE"."PURC_ORDER_ID" ) } WHERE
(("SYSADM"."PURCHASE_ORDER"."STATUS" IN ('F' ,'R' ) ) AND
("SYSADM"."PURCHASE_ORDER"."BUYER" = 'WILL' ) ) \ 0"
in the SQLstatement it has {oj xxxxxx}. Does anyone know where the {oj }
is coming from. This seems to be the problem. Is this used or a part of a
regular statement for SQLServer. Would like any ideas.
Thanks
coming from. What I have is a SQLBase server made by Unify company. I am
trying to make an Access 2003 report. 2 tables Purchase_Order and
Purc_Order_Line. There are times when the purchasing dept starts a purchase
order but never puts any lines in. I would like to be able to report these
headers. I make the Join in the SQL statement a outer join where the table
Purchase_Order has records and the Purc_Order_Line table may not. I get the
error
ODBC Call Fail
[Gupta][ODBC Driver]][Parseer][Position (39,92)] 'Outer Join' Key word is
missing (3-19)
I ran the ODBC trace and contacted Unify and my contact there said that it
is producing a strange SQLStatement. It is
"SELECT
"SYSADM"."PURCHASE_ORDER"."ID","SYSADM"."PURC_ORDER_LINE"."PURC_ORDER_ID","SYSADM"."PURC_ORDER_LINE"."LINE_NO"
FROM {oj "SYSADM"."PURCHASE_ORDER" LEFT OUTER JOIN "SYSADM"."PURC_ORDER_LINE"
ON ("SYSADM"."PURCHASE_ORDER"."ID" =
"SYSADM"."PURC_ORDER_LINE"."PURC_ORDER_ID" ) } WHERE
(("SYSADM"."PURCHASE_ORDER"."STATUS" IN ('F' ,'R' ) ) AND
("SYSADM"."PURCHASE_ORDER"."BUYER" = 'WILL' ) ) \ 0"
in the SQLstatement it has {oj xxxxxx}. Does anyone know where the {oj }
is coming from. This seems to be the problem. Is this used or a part of a
regular statement for SQLServer. Would like any ideas.
Thanks