Can someone point me in the right direction [message #629750] |
Mon, 15 December 2014 20:32 |
|
morrism35
Messages: 10 Registered: December 2014
|
Junior Member |
|
|
Not asking someone to do this for me but at least point me in the right direction. My idea is select * from tasks where
&taskId=StatusID; Something is missing here if only this where java or c++ I could use a IF lol. This is
a extra credit for my final exam. I finished my final but this one is one of those out of the way questions
that instructors ask you. It's due by midnight so I'm really working hard on this one since late last night.
The instructors want to be able to select all of the tasks that have the same task as one that they are viewing.
Please create a query that will allow them to select all of the tasks with the same status as a task that they enter by TaskID.
Tablename: Tasks
Fieldname Datatype Null Comments
TaskID Number(3) Not null Unique identifier for the table
TaskName Varchar2(20) Not null Name of the task
TaskDesc Varchar2(20) Null Details of the task
DueDate Date Null Task due date
PriorityID Char(1) Null FK to Priority table
StatusID Char(1) Null FK to Status table
Tablename: Priority
Fieldname Datatype Null Comments
PriorityID Char (1) Not null Unique identifier for the table
PriorityName Varchar2(20) Not null Assigns priority level to a task
Tablename: Status
Fieldname Datatype Null Comments
StatusID Char(1) Not null Unique identifier for the table
StatusName Varchar2(20) Not null Assigns a category to a task
|
|
|
|
|
|
|
|
|