When access generates SQL tables, it always prompts syntax errors when running. Please ask an expert to see where I went wrong.

The first three are no problem, but there are many problems with the last SPJ CREATE? /p>

PNO?SMALLINT,?

JNO?SMALLINT,?

QTY?CHAR(20),--This field is a quantity and should be in numeric type, but Although the character type you used does not report an error, it is wrong when you calculate it, so I won’t change it for you. Please change it yourself. Also, there must be a comma after it

FOREIGN?KEY?(? SNO?)?REFERENCES?S?(?SNO?),

FOREIGN?KEY?(?PNO?)?REFERENCES?P?(?PNO?),?--You seem to have less of this place commas

FOREIGN?KEY?(JNO)?REFERENCES?J(JNO));