Outer join in Access

Hello!

I have a table (texts), it has only four columns TextForm, TextComponent,
TextLanguage and Text (all except Text are index)
If I do the following select I get all english texts (returns about 100
rows):

Select TextComponent, Text
From Texts
Where TextForm = 'MainForm'
And TextLanguage = 44

Now I would like to outer join and additionally get all Swedish text if they
exist, otherwice just a blank text

Select Eng.TextComponent, Eng.Text, Swe.Text
From Texts Eng
Left Join Texts Swe On Swe.TextForm = Eng.TextForm And Swe.TextComponent =
Eng.TextComponent
Where Eng.TextForm = 'MainForm'
And Swe.TextForm = 'MainForm'
And Eng.TextLanguage = 44
And Swe.TextLanguage = 46

The problem here is I don't get an Outer join! I only get the rows returned
where I also have an Swedish text! (only one row).
Also tried "Left outer join" with same result.
Is there a problem in Access to join with the same table?

Please help...

regards, Mikael


.