Here you have asked some questions. To address points:
In the FROM
a
used as an alias for the invheader
table. This means that you can refer to this table with a short alias a
instead of the full name of the table.
Therefore, a.id
refers to the id
column of the invheader
table.
It is generally believed that bad practice simply gives your tables aliases a
, b
, c
, etc., and I would recommend that you use something more useful.
I suggest you familiarize yourself with some of the basic MySQL tutorials, as this is a fundamental principle.
source share