Hi guys!
please tell me - where is error here -

select `OWNER.OWNER_ID`, `Previous_owner.GDATE`  from `Previous_owner` left join `OWNER` on
 `Previous_owner.OWNER_ID`=`OWNER.OWNER_ID` 
 left join `AVTO` on `Previous_owner.OWNER_ID`=`AVTO.OWNER_ID`  where `AVTO.AVTO_ID` = 3

phpmyadmin shows error -

#1054 - Unknown column 'OWNER.OWNER_ID' in 'field list'

the db structire is =

create table AVTO
(
  AVTO_ID   INT not null AUTO_INCREMENT PRIMARY KEY,
  MARKA VARCHAR(100),
  KN INT,
  DN INT,
  OWNER_ID INT
);
create table OWNER
(
  OWNER_ID INT not null AUTO_INCREMENT PRIMARY KEY,
  NAME VARCHAR(100),
  UN INT
);
create table Previous_owner
(
  OWNER_ID INT ,
  AVTO_ID INT,
  GDATE  TIMESTAMP
);

big thanks in advance!))

Recommended Answers

All 2 Replies

Erase all back-ticks.
`OWNER.OWNER_ID` is interpreted as a field name, not as a table- plus field name.
Or code `OWNER`.`OWNER_ID` (urrhg)

commented: +++++++++++ +3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.