Problem with left join select command ??

Hello Everybody

 

Left join problem with maxdb 7.6.00.25 (64 bit on suse linux)

 

I have 3 tables stpersonalstamm,lolohnkopf,lolohndaten

The link between stpersonalstamm and lolohnkopf is stpersonalstammid

The link between lolohnkopf and lolohndaten is lolohnkopfid

 

 

In lolohnkopf there can be 1 to n records for a stpersonalstammid for a
given lofuerjahr,lofuermonat but don't have to

In lolohndaten there can be 1 to n records for a lolohnkopfid but don't
have to

 

I want to search all records from stpersonalstamm and find out wether
they have entries in lolohnkopf and in lolohndaten or not

 

select * from stpersonalstamm             

 left join lolohnkopf on stpersonalstamm.stpersonalstammid =
lolohnkopf.stpersonalstammid 

 and lolohnkopf.lofuerjahr = ?l_jj and lolohnkopf.lofuermonat = ?l_mm 

 left join lolohndaten on lolohndaten.lolohnkopfid =
lolohnkopf.lolohnkopfid     

 where stpersonalstamm.stnlstammid = ?P_stnlstammid 

 and stpersonalstamm.staustritt >= ?l_aktdatum 

 and stpersonalstamm.steintrittnl <= ?l_lastdatum 

 order by stpersonalstamm.stpersonalstammid "

 

I expected a result cursor with all columns from stpersonalstamm , 

all columns from lolohnkopf (filled or null) and all columns from
lolohndaten (filled or null)        

 

If there are some records in lohnkopf for a given lofuermonat,lofuerjahr
the select works as expected.

The lolohnkopf part of the result cursor is filled with correct data or
null values

 

But if there are no records in lolohnkopf for a given
lofuermonat,lofuerjahr the result cursor is empty ???????????


 

Any help welcomed

 

Best regards

Albert