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 |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2001-07-11 : 16:55:10
|
| SELECT Task.[Job #], Task.[Tracking Code], [Worker Extended].EmpName, [Rate Schedule].RateDate, [Rate Schedule].[Rate End Date], [Rate Schedule].IntJobDesc, [Rate Schedule].IJDRate AS SRate, [Rate Schedule].IJDRateOT AS SRateOTFROM (((Task INNER JOIN [Tracking Metrics] ON Task.[Tracking Code] = [Tracking Metrics].[Tracking Code]) INNER JOIN [Rate Schedule] ON [Tracking Metrics].[Rate Schedule] = [Rate Schedule].[Rate Schedule]) INNER JOIN [Job Class] ON [Rate Schedule].IntJobDesc = [Job Class].[Job Description]) INNER JOIN [Worker Extended] ON [Job Class].[Job Description] = [Worker Extended].IntJobDesc1; |
|
|
|
|
|
Can This Be Optimized