我有三个表:
Meeting(MeetingID,MeetingTitle,MeetingContent,MeetingTime)
dep(depID,depName);
deppeo(peoID,peoName,depID)
我想实现:
选择从三个表中除MeetingID,depID,peoID以外的所有字段,语句应该怎么写???
就相当与我要在DataGrid里面显示出以上数据:
string str=“select ........from.......“
Meeting(MeetingID,MeetingTitle,MeetingContent,MeetingTime)
dep(depID,depName);
deppeo(peoID,peoName,depID)
我想实现:
选择从三个表中除MeetingID,depID,peoID以外的所有字段,语句应该怎么写???
就相当与我要在DataGrid里面显示出以上数据:
string str=“select ........from.......“
我把dep(depID)设为主键,而deppeo(depID)设置成外键。
Meeting(MeetingID,MeetingTitle,MeetingContent,MeetingTime)
dep(depID,depName);
deppeo(peoID,peoName,depID)
//*****将三个表建立关系就可以了三
SELECT MeetingID,MeetingTitle,MeetingContent,MeetingTime,depID,depName,peoName,depID
FROM MEETING INNER JOIN DEP ON DEP.DEPID=MEETING.DEPID INNER JOIN deppeopeoID ON
deppeopeoID.deppeopeoID=MEETING.deppeopeoID