Re: Outer join in Access


Hello!

I tried that but I get an error message "Connection expression not
supported" (or something like that, text in swedish). Thats why I moved the
"And Swe.TextLanguage = 46" to the bottom.

Then try this version

Select Eng.TextComponent, Eng.Text, Swe.Text
From Texts Eng
Left Join (Select * from Texts where TextLanguage = 46) Swe
On Swe.TextForm = Eng.TextForm
And Swe.TextComponent = Eng.TextComponent
Where Eng.TextForm = 'MainForm'
And Eng.TextLanguage = 44
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Outer join in Access
    ... I tried that but I get an error message "Connection expression not ... text in swedish). ... Thats why I moved ...
    (borland.public.delphi.database.ado)
  • Re: Summing all BUT one...
    ... Peo Sjoblom ... Or start a new post with a subject line of: translate formula to Swedish ... Excel gives me a error message with that code. ...
    (microsoft.public.excel.worksheet.functions)
  • Naming information cannot be located because...
    ... Thats the error message I got while triyng to open AD ... Users and Computers Snap In on a DC for a domain. ...
    (microsoft.public.win2000.active_directory)
  • RE: scanner and camera wizard
    ... got that error message, thats the whole thing. ... "Jonybrv" wrote: ... >>> wizard page that is not valid ...
    (microsoft.public.windowsxp.general)
  • Re: XMLSolution Error Message
    ... CrLf at the end of the string. ... Thats all, remove it and it will work. ... > get the same error message. ... > Ungültiger Parameter ...
    (microsoft.public.visio.developer.vba)