Welcome Guest, Not a member yet? Register   Sign In
How to fix results key from a joined query
#2

[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.


Messages In This Thread
How to fix results key from a joined query - by El Forum - 05-23-2009, 09:46 AM
How to fix results key from a joined query - by El Forum - 05-24-2009, 01:20 AM
How to fix results key from a joined query - by El Forum - 05-24-2009, 10:11 AM
How to fix results key from a joined query - by El Forum - 05-24-2009, 12:13 PM
How to fix results key from a joined query - by El Forum - 05-24-2009, 12:17 PM



Theme © iAndrew 2016 - Forum software by © MyBB