create view error

Hi folks,

I know I'm missing something blindingly obvious, can someone point it out to 
me please.

create table locos (        -- Locos table - contains details of locos
lid         int4 default nextval('loco_lid_seq'::text) unique not null,
lclass        int4 references lclass(lcid),    -- Loco Class
lbuilt        date,                -- Date off-shed
lcme        int4 references cme(cmid),     -- Chief Mechanical Engineer
lname        character varying(30),        -- Name of Loco
lcomments    text                -- free text comments
);
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'locos_lid_key' for 
table 'locos'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE
create table lnumbers ( -- alternate loco numbers
lnid        int4 not null references locos(lid),
lnumber        character varying(10),
lncurrent    bool,
primary key    (lnid, lnumber)
);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'lnumbers_pkey' 
for table 'lnumbers'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE
create view loco_dets as select * from locos l     left outer join        (select * from lclass) lc on lc.lcid =
l.lclass    left outer join       (select lnumber from lnumbers) ln on ln.lnid = l.lid and ln.lncurrent 
 
= true     left outer join       (select * from company) c on c.coid = lc.lcompany;
ERROR:  No such attribute or function ln.lnid
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000