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 |
|
kamikaze
Starting Member
8 Posts |
 Posted - 2010-03-10 : 08:40:05
|
| SELECT tblJobDetails.*, OwnedVehicle.CO2 AS VCO2, ([EndMileage]-[StartMileage]*([VCO2])) AS tot1, tblPostcodes.x AS xPosd, tblPostcodes.y AS yPosdFROM tblStatus INNER JOIN (tblPostcodes INNER JOIN (tblJobDetails LEFT JOIN OwnedVehicle ON tblJobDetails.VehicleID = OwnedVehicle.VehicleID) ON tblPostcodes.PostcodeID = tblJobDetails.PostcodeID) ON tblStatus.StatusID = tblJobDetails.StatusID;can anybody convert this JET SQL statement to T-SQL? the problem lies when i call VCO2 in my calulation. Since this is an expression from a previuos line in the same query. how do i go about making this work and retain my expression collumn.ummm... |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Convert this basic Jet SQL statement to T-SQL