Hi sqlite-users,
I have a following problem. In my database there are 3 table:
CREATE TABLE [Samochody]
(
        [IDsam] integer, 
        [Samochod] varchar (50),
        PRIMARY KEY ([IDsam])
);

CREATE TABLE [Modele]
(
        [IDmod] integer,
        [IDsam] integer, 
        [Model] varchar (50),
        PRIMARY KEY ([IDmod])
);
CREATE TABLE [PomiarBledow]
(
        [IDpomiaru] integer, 
        [IDmod] integer, 
        [IDkol] integer,
        PRIMARY KEY ([IDpomiaru])
);

In tables are some hypothetical data:
INSERT INTO [Samochody] ([Samochod]) VALUES ('Number1');  /-> IDsam=1;

INSERT INTO [Modele] ([IDsam], [Model]) VALUES ('1', 'Bus');   /->
IDmod=1;
INSERT INTO [Modele] ([IDsam], [Model]) VALUES ('1', 'Truck'); /->
IDmod=2;

INSERT INTO [PomiarBledow] ([IDmod], [IDkol]) VALUES ('1', '1');  /->
IDpomiaru=1;
INSERT INTO [PomiarBledow] ([IDmod], [IDkol]) VALUES ('1', '2');  /->
IDpomiaru=2;
INSERT INTO [PomiarBledow] ([IDmod], [IDkol]) VALUES ('2', '4');  /->
IDpomiaru=3;
INSERT INTO [PomiarBledow] ([IDmod], [IDkol]) VALUES ('2', '5');  /->
IDpomiaru=4;

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?

Regards
WojciechW.

Reply via email to