Delete the , after KEY and give owner a datatype and everything works fine. I have tested. Jesus. On Wed, 5 Jul 2000, planx plnetx wrote: > > > CREATE TABLE workers( > > > name varchar(30), > > > firstname varchar(30), > > > id_personal decimal(10)NOT NULL UNIQUE PRIMARY KEY, > > > ); > > > > > > CREATE TABLE payements( > > > date_of date, > > > owner REFERENCES workers(id_personal) > > > );
- Re: [GENERAL] REFERENCES troubles planx plnetx
- Jesus Aneiros