ODBC and complex joins

[eluser]WanWizard[/eluser]
The column name is used as fieldname in the resultset. If your query contains duplicate column names, only the last one is stored. This is not specific to the ODBC driver, this is how all drivers work.

I think the question should be: why doesn't 'AS' in the select work as intended? Because the result says 'Id', it should have shown 'so_number' and 'circuit_id'. No answer to that I'm afraid. You could dive into the driver, and do a var_dump of the raw result of odbc_result(). Then at least we'll know if it's a CI issue or a PHP / ODBC / Driver / MSSQL issue...