create table questionType(
qid int primary key,
typename varchar2(200) not null)create table question(
tid int primary key,
content varchar2(200) not null,
qid int references questionType(qid)
)
select question.qid,question.content from question left join questiontype on question.qid = questionType.Qid我这样写错了吗?总是报sql语句未正确结束
qid int primary key,
typename varchar2(200) not null)create table question(
tid int primary key,
content varchar2(200) not null,
qid int references questionType(qid)
)
select question.qid,question.content from question left join questiontype on question.qid = questionType.Qid我这样写错了吗?总是报sql语句未正确结束
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
create table questionType(
qid int primary key,
typename varchar2(200) not null
);
create table question(
tid int primary key,
content varchar2(200) not null,
qid int references questionType(qid)
);
select question.qid,question.content from question left join questiontype on question.qid = questionType.Qid;