ERROR 1054 (42S22) at line 1: Unknown column 'a.pid' in 'field list'

[dharokko 7]

Hello,

i've an Error "ERROR 1054 (42S22) at line 1: Unknown column 'a.pid' in 'field list'"
If i compile my questes and write /reload q for testing progress my server is crashing.

I finde some informations about the "a.pid" in my DB.

can someone help me with this Error? 

[Dr3Ame3r 36]

Hello,

A similar syntax could be "SELECT pid from account as a"

 

'a' stands for a definition of a table, that syntax is used when a query contains JOINs.

 

We'd like to see your issue or where it comes from.

 

Best regards,

Dr3Ame3r

[WeedHex 661]

INNER JOIN