Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pnasz
Posting Yak Master
101 Posts |
 Posted - 2010-10-02 : 02:22:44
|
| I have two table employee and schedule employee where i am having all details of employeeand schedule for employee in the form of schedule id like mon=1 tuesday=1 thu 3 etc.in schedule table i am having schid, timein, timeouti want to run the query where i will get all empdetail + timein , timeout for mon,tue and thursday |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-02 : 02:47:59
|
| do you mean you dont have empid in schedule table? then how are you relating it to an employee?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
help needed