Re: MIMER - Invalid construction

From: Anders Gustavson <anders.gustavson_at_ite.his.se>
Date: Mon, 14 May 2001 14:03:46 +0200
Message-ID: <3AFFC9A2.1A5C3079_at_ite.his.se>

"Per Schr?er" wrote:
>
 

> Anders Gustavson <anders.gustavson_at_sta.his.se> wrote in
> <3AFA795D.2459E054_at_sta.his.se>:
>
 

> >I'm having some problems with the following SQL query, can anyone
> >explain why MIMER think it's invalid.
> >
> >SELECT ANTLIN.PNR, NAMN.TNAMN, namn.enamn
> >FROM NAMN, ANTLIN left join GRUPPRAD on GRUPPRAD.PNR = ANTLIN.PNR
> >WHERE namn.pnr tlin.pnr and antlin.progr='DEI' and antterm='19
 99'
> >AND (antlin.pnr IN (select distinct pnr from KURS
> > where termin='2001' and progr='DEI'))
>
 

> I tried this query and had no problems (Mimer V822). (Using my own tabl
 es
> of course.)
>
 

> What version are you running?
 7.3
> Exactly what error message do you get?
I get following information from SQL Query Builder Native Error: -12104
Driver Error: S1000
Error text: [MIMER][ODBC MIMER Driver][MIMER/DB]Invalid construction

---

Anders Gustavson email:anders_at_ite.his.se systemadministrat? www:http://www.his.se/ite/~anders Received on Mon May 14 2001 - 14:03:46 CEST