Re: [sqlite] Problem with (??) INNER JOIN

[Jay Sprenkle]

On 3/2/06, erw2 <[EMAIL PROTECTED]> wrote:
>
> Now I try to execute SQL query:
> SELECT PomiarBledow.IDpomiaru, Samochody.Samochod
> FROM (PomiarBledow INNER JOIN Modele ON PomiarBledow.IDmod =
> Modele.IDmod) INNER JOIN Samochody ON Modele.IDsam = Samochody.IDsam
> WHERE (((PomiarBledow.IDpomiaru)=2));
>
> and I get en error: "Error 1 - No such column: PomiarBledow.IDpomiaru"
> In MSAccess there is no problem to execute such query. What is wrong
> with it?
>

does this work?
SELECT PomiarBledow.IDpomiaru, Samochody.Samochod
   FROM PomiarBledow
 INNER JOIN Modele ON PomiarBledow.IDmod = Modele.IDmod
 INNER JOIN Samochody ON Modele.IDsam = Samochody.IDsam
WHERE PomiarBledow.IDpomiaru=2