[RESOLVED] Complex SELECT Query

[twilliamsen]

I have a complex select query, and I wanted to make employees_0.Manager to be distinct since there is several entries in there

SELECT employees_0.CollectorCode, employees_0.Extension, employees_0.Manager, CONCAT(employees_0.FirstName,' ',employees_0.LastName)
FROM move_db.employees employees_0
WHERE employees_0.Manager = DISTINCT
ORDER BY employees_0.Manager, employees_0.LastName

Btw, this is being dumped into an Excel Spreadsheet, thus thats why the query looks weird.

I wanted it to out like this

Manager

(people that are managedd by the manager) Firstname Lastname

I tried throwing DISTINCT in there but mySQL freaked out. It said error on line 2 dumbazz

[Roger_Ramjet]

You cannot get what you want from any query, relational dbs just don't work that way. What you have to do is to process the output in code before writing it to the excel file.

DISTINCT is an sql operator and is not used like that either.

[twilliamsen]

resolved... went with something else. Became too complex to manipulate the data at the server level. Need to spend $$$ on crystal reports