cannot find table or constraint

[HAREM]

Create table costumer
(costumer_id int primary key,
first_name char(100) null,
last_name char(100)not null,
email char(100) not null,
address char(100) not null,
city char(100) not null,


state char(100) not null,
zipcode number not null);

INSERT INTO COSTUMER
VALUES (1, 'George', 'Wali', 'jw@email.com', 'FB area', 'Karachi', 'PK', '2211');





create table orders(order_id int primary key,
amount int,
costumer_id int,
foreign key(costumer_id) references costumers(costumer_id));

after running second table the error message occurs...

[davegri]

create table orders(order_id int primary key, 
amount int, 
costumer_id int, 
foreign key(costumer_id) references costumers(costumer_id));

Spelling error

[HAREM]

where is spelling error?

[davegri]

where is spelling error?

table name is costumer not costumers

[HAREM]

Relationship must be on the same number of fields with the same data types. this error comes in

[HAREM]

Select first_name, last_name, amount
from costumer as d inner join orders as o on d.customer_id=o.customer_id;

[davegri]

Select first_name, last_name, amount
from costumer as d inner join orders as o on d.customer_id=o.customer_id;

Let's get some consistency here. Is it Costumer or Customer? Let's not have both!