When using SQL multi-table join queries, can appear the following problems
SELECT
I.K C AS Chinese,
M.K C1 AS literature
The FROM INVOICE_MAIN M, INVOICE_ITEM I
WHERE I.I AND D=M.I D
I.I D='28 d5dbec8081002adaffc96100a27760'
Title will be displayed as shown in the following

IVNOICE_MAIN INVOICE_ITEM
Chinese literature

After why English field into a Chinese name, automatically added in front of the name of the table, isn't there any way to only show Chinese

CodePudding user response:

Select a=1
In this way the names

CodePudding user response:

If used AS an alias to quotes