|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
SQL Please help
Hello,
I have three tables having emp_id and name, hirearchy of employees in the emp table, project status, hours worked, date in the status table and the third table I use to link the first two table becuase only the third table and the status table has common fields. What I wanted is to get employess who worked less than 8 hours. How to get this query? Pls help me. Thanks in advance. Ponic |
|
#2
|
|||
|
|||
|
Because you did not send the complete description of tables, so it is difficult to write a query without knowing the structure of those tables you are working on.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > SQL Please help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|