[eluser]Jfly[/eluser]
[quote author="OverZealous" date="1280334926"]@Jfly
That's not a mistake. That's the table alias. It does it for all joins, because they are sometimes different, and it has never given me a problem.[/quote]
I just found out that the problem is caused by my table name, which is conflicted with mysql reserved names. However, I never have this kind of problem, because I use prefix for table names. I think the problem here is that DMZ removes prefix in the table alias.