Re: MIMER - Invalid construction

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=antlin.pnr and antlin.progr='DEI' and antterm='1999'
>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 tables of course.)

What version are you running?
Exactly what error message do you get?

-- 
/Per Schröder
http://developer.mimer.com