Hey guys. Can you have a look at my queries? I can't spot the error with my foreign key linking.
As of now, the table staff has already existed:
And now I'm trying to create a new table called SalesInvoice:
create table SalesInvoice(
foreign key (Sales_Person) references staff(StaffID));
when I execute the query, it gives me Error 1005, I've looked around in google and this forum, it seems to be foreign key related?