Umm..ok..so now I feel a little dumb. It still doesn't work :-\
Select Team_Tbl.Service_Area,
Team_Tbl.Cost_Center_Cd,
Team_Tbl.Cost_Center_Desc,
tblServiceArea.Service_Area,
tblServiceArea.Service_Area_Desc AS ServiceDescription
FROM tblServiceArea,Team_Tbl
WHERE
tblServiceArea.Service_Area = Team_TBL.Service_Area
ORDER BY ServiceDescription
This is Oracle 8i which really shouldn't matter for such SIMPLE
GODDAMNED CODE!! ARRGGHH!
WHAT am I doing WROOOoonnnNNNNGGGgggiiieeeee!
-Gel
-----Original Message-----
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Try aliasing your table columns. ORDER BY only looks at the final
recordset, so depending on which DB you're using, it might be ignoring
your ORDER BY.
SELECT
users.userID AS userID,
users.lastName AS lastName,
departments.deptName AS departmentName
FROM users,departments
WHERE users.deptID = departments.deptID
ORDER BY departmentName
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists