How to fix results key from a joined query

[eluser]vps4[/eluser]
[quote author="depthcharge" date="1243167627"]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.[/quote]

thanks for reply.
but fanit, the SQL will be too long...
any other ways?