I have a query and I am not sure why it doesnt return any lines. I am building some kind of a bug system and I want to show all the kinds of fields. I have 2 main tables: users, tickets. Now, I made reationship between them and for each reported by I want to assign an name of user by his id in the user table. The same goes for assign to. When I ran this query:
"SELECT UsersTbl.Name AS first, UsersTbl.Name AS second
FROM Tickets INNER JOIN
UsersTbl ON Tickets.Reported_by = UsersTbl.Id INNER JOIN
UsersTbl AS UsersTbl_1 ON Tickets.Assign_to = UsersTbl.Id"
I dont get any thing in return. Why ?