由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Access help
相关主题
Join optimizationmySQL怎么这么慢?
高手请进,问个SQL问题如何用join ... on语句查询三张表
1. Oracle vs. SQL92 Re: Just一个有关查询的语句
一个schema求教WebDB
公司又RE-ORGANIZE了multicolumn primary key ?
Re: [转载] what's the equivalent of 'minus' (oracle) in access?Help on migrating oracle to db2, outerjoin
primary key?哪位大虾精通FILEMAKER?如何定义多个ATTRIBUTES为PRIMARY KEY?
how to get primary key through JDBC?Come to join us!
相关话题的讨论汇总
话题: staffid话题: access话题: primary话题: projectid话题: table
进入Database版参与讨论
1 (共1页)
m******1
发帖数: 1
1
I need to create a database for our 6 to 8 people to tracking time and cost
spending on each project.
I have created 3 major tables.
One is staff table. Which has staff id( primary key), name, rate…
One is project table. Which has projected(primary key), name….
One is StaffStudy table, which has staffID and projected joined as primary
key…
I have another table which will store StaffID, ProjectID, Date and hours.
Which has StaffID, ProjectID, Date joined as primary key.
I need to create a form th
B*****g
发帖数: 34098
2
不太清楚你再问什么?
难道不是 SELECT ProjectID FROM StaffStudy WHERE staffID = :SELECT ?

cost
if
are

【在 m******1 的大作中提到】
: I need to create a database for our 6 to 8 people to tracking time and cost
: spending on each project.
: I have created 3 major tables.
: One is staff table. Which has staff id( primary key), name, rate…
: One is project table. Which has projected(primary key), name….
: One is StaffStudy table, which has staffID and projected joined as primary
: key…
: I have another table which will store StaffID, ProjectID, Date and hours.
: Which has StaffID, ProjectID, Date joined as primary key.
: I need to create a form th

1 (共1页)
进入Database版参与讨论
相关主题
Come to join us!公司又RE-ORGANIZE了
need more free booksRe: [转载] what's the equivalent of 'minus' (oracle) in access?
How to find primary keyprimary key?
about joinshow to get primary key through JDBC?
Join optimizationmySQL怎么这么慢?
高手请进,问个SQL问题如何用join ... on语句查询三张表
1. Oracle vs. SQL92 Re: Just一个有关查询的语句
一个schema求教WebDB
相关话题的讨论汇总
话题: staffid话题: access话题: primary话题: projectid话题: table