How to fix results key from a joined query

[eluser]depthcharge[/eluser]
use Aliases

i.e

Code:

SELECT a.ID AS ID, n.node_title AS node_title .........

I tend to stay away from using table.* and state the field names where possible, but that's just my preference.