MySQL query prob.

[thecookie]

I am having probs with this query, I get all data but "Headenhet". Thanks for any help!

SELECT u.PhoneNr, u.Comment, u.HiredFrom, b.Befattning, e.Kortnamn, e.EnhID, e2.Kortnamn as Headenhet, usr.Firstname, usr.Lastname
FROM enhet_users u
LEFT JOIN Users usr ON (u.user_id = usr.id)
LEFT JOIN Enhet e ON (e.EnhID = u.enhet_id)
LEFT JOIN Enhet e2 ON (e.EnhID = usr.EnhID)
LEFT JOIN Befattning b ON (u.Befattning = b.id)
WHERE u.user_id = '$_GET[User_ID]'

[tomhath]

Did you mean e2.EnhID here?

LEFT JOIN Enhet e2 ON (e.EnhID = usr.EnhID)

[thecookie]

Yeah. Just solved it.. I must have been tired or something.. 😉
typed:
LEFT JOIN Enhet e2 ON (e.EnhID = usr.EnhID)
instead of:
LEFT JOIN Enhet e2 ON (e2.EnhID = usr.EnhID)