|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
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
May 4th, 2004, 03:37 AM
|
|||
|
|||
|
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
May 5th, 2004, 07:57 AM
|
|||
|
|||
|
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 |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
