Left outer join problem in CR9 through ODBC

[CR8563]

Hi,

I have a problem with a left outer join in the database expert.
I join two tables with a left outer join and it appears like it is like an inner join.

My database is pervasive2000. I have a connection through ODBC.

I found a document on the "Cr9_left_outer_join.pdf" and I added my driver to a registry key. But left outer join works like a inner join.

How can I solve this problem.

Thanks in advance !!

[sameerteni]

Can u paste your query for this.

Regards,
Sameer

[CR8563]

My Query looks very normal to me, like

SELECT "res"."res_labonr", "sub"."sub_subnr", "res"."res_meth", "res"."res_sub", "sub"."sub_sub"
FROM {oj "res" "res" LEFT OUTER JOIN "sub" "sub" ON "res"."res_sub"="sub"."sub_subnr"}
WHERE "res"."res_labonr"=1 AND "sub"."sub_sub"=0

So on SQL server, Quoted identifier woeld be on. But for this project I work on a pervasive2000 database.

The query is like an left outer join, but its behavior is like an inner join. So Normaly I would see 5 records out the res table, but now I see only the 2 matching records.

Yeah, therefore I use left outer join to see alse the 3 other records. But it doesn't work here.

Eddy