| IN NEED OF SQL STATEMENT PLEASE [message #374966] |
Mon, 16 July 2001 06:34  |
sai krishna
Messages: 8
Registered: July 2001
|
Junior Member |
|
|
I have two master tables
1)employee with emp_id & emp_name
2)status with status_id & status
One detail Table
1)Sales_Report with
status_id(reference status table),school_name,emp_id(reference employee table),action_date,next_action(reference employee table),next_action_status(reference status table),next_action_date,comments
I need one sql statement which will give me all the details as follows:
status,school name,employee name,action_date, employee name,status,next_action_date,comments
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
