不是Select * 增加的是t_item表的字段SELECT dbo.T_SALESORDHDR.*, dbo.T_TRDTYPE.F_DESC AS TRADEDESC, dbo.T_ITEM.F_DESC AS ITEMDESC, dbo.T_INVOTYPE.F_DESC AS INVOTYPEDESC, dbo.T_PAYTERM.F_DESC AS PAYTERMDESC, dbo.T_PAYTYPE.F_DESC AS PAYTYPEDESC, dbo.T_CUST.F_NAMESHT AS F_NAMESHT, dbo.T_EMP.F_NAME AS F_NAME, dbo.T_EMP.F_LOGIN AS F_LOGIN, dbo.T_ITEMTYPE.F_ISBOARD AS ITEMTYPEISBOARD FROM dbo.T_EMP INNER JOIN dbo.T_ITEMTYPE INNER JOIN dbo.T_ITEM ON dbo.T_ITEMTYPE.F_ID = dbo.T_ITEM.F_ITEMTYPE INNER JOIN dbo.T_PAYTERM INNER JOIN dbo.T_INVOTYPE INNER JOIN dbo.T_PAYTYPE INNER JOIN dbo.T_CUST INNER JOIN dbo.T_TRDTYPE INNER JOIN dbo.T_SALESORDHDR ON dbo.T_TRDTYPE.F_ID = dbo.T_SALESORDHDR.F_TRDTYPE ON dbo.T_CUST.F_ID = dbo.T_SALESORDHDR.F_CUSTID ON dbo.T_PAYTYPE.F_ID = dbo.T_SALESORDHDR.F_PAYTYPE ON dbo.T_INVOTYPE.F_ID = dbo.T_SALESORDHDR.F_INVOTYPE ON dbo.T_PAYTERM.F_ID = dbo.T_SALESORDHDR.F_PAYTERM ON dbo.T_ITEM.F_ID = dbo.T_SALESORDHDR.F_ITEMID ON dbo.T_EMP.F_ID = dbo.T_CUST.F_EMPID
SELECT dbo.T_SALESORDHDR.*, --这不是表示*是什么? 问题就在这 dbo.T_TRDTYPE.F_DESC AS TRADEDESC, dbo.T_ITEM.F_DESC AS ITEMDESC, dbo.T_INVOTYPE.F_DESC AS INVOTYPEDESC, dbo.T_PAYTERM.F_DESC AS PAYTERMDESC, dbo.T_PAYTYPE.F_DESC AS PAYTYPEDESC, dbo.T_CUST.F_NAMESHT AS F_NAMESHT, dbo.T_EMP.F_NAME AS F_NAME, dbo.T_EMP.F_LOGIN AS F_LOGIN, dbo.T_ITEMTYPE.F_ISBOARD AS ITEMTYPEISBOARD FROM dbo.T_EMP INNER JOIN dbo.T_ITEMTYPE INNER JOIN dbo.T_ITEM ON dbo.T_ITEMTYPE.F_ID = dbo.T_ITEM.F_ITEMTYPE INNER JOIN dbo.T_PAYTERM INNER JOIN dbo.T_INVOTYPE INNER JOIN dbo.T_PAYTYPE INNER JOIN dbo.T_CUST INNER JOIN dbo.T_TRDTYPE INNER JOIN dbo.T_SALESORDHDR ON dbo.T_TRDTYPE.F_ID = dbo.T_SALESORDHDR.F_TRDTYPE ON dbo.T_CUST.F_ID = dbo.T_SALESORDHDR.F_CUSTID ON dbo.T_PAYTYPE.F_ID = dbo.T_SALESORDHDR.F_PAYTYPE ON dbo.T_INVOTYPE.F_ID = dbo.T_SALESORDHDR.F_INVOTYPE ON dbo.T_PAYTERM.F_ID = dbo.T_SALESORDHDR.F_PAYTERM ON dbo.T_ITEM.F_ID = dbo.T_SALESORDHDR.F_ITEMID ON dbo.T_EMP.F_ID = dbo.T_CUST.F_EMPID
增加的是t_item表的字段SELECT dbo.T_SALESORDHDR.*, dbo.T_TRDTYPE.F_DESC AS TRADEDESC,
dbo.T_ITEM.F_DESC AS ITEMDESC, dbo.T_INVOTYPE.F_DESC AS INVOTYPEDESC,
dbo.T_PAYTERM.F_DESC AS PAYTERMDESC,
dbo.T_PAYTYPE.F_DESC AS PAYTYPEDESC,
dbo.T_CUST.F_NAMESHT AS F_NAMESHT, dbo.T_EMP.F_NAME AS F_NAME,
dbo.T_EMP.F_LOGIN AS F_LOGIN,
dbo.T_ITEMTYPE.F_ISBOARD AS ITEMTYPEISBOARD
FROM dbo.T_EMP INNER JOIN
dbo.T_ITEMTYPE INNER JOIN
dbo.T_ITEM ON dbo.T_ITEMTYPE.F_ID = dbo.T_ITEM.F_ITEMTYPE INNER JOIN
dbo.T_PAYTERM INNER JOIN
dbo.T_INVOTYPE INNER JOIN
dbo.T_PAYTYPE INNER JOIN
dbo.T_CUST INNER JOIN
dbo.T_TRDTYPE INNER JOIN
dbo.T_SALESORDHDR ON
dbo.T_TRDTYPE.F_ID = dbo.T_SALESORDHDR.F_TRDTYPE ON
dbo.T_CUST.F_ID = dbo.T_SALESORDHDR.F_CUSTID ON
dbo.T_PAYTYPE.F_ID = dbo.T_SALESORDHDR.F_PAYTYPE ON
dbo.T_INVOTYPE.F_ID = dbo.T_SALESORDHDR.F_INVOTYPE ON
dbo.T_PAYTERM.F_ID = dbo.T_SALESORDHDR.F_PAYTERM ON
dbo.T_ITEM.F_ID = dbo.T_SALESORDHDR.F_ITEMID ON
dbo.T_EMP.F_ID = dbo.T_CUST.F_EMPID
dbo.T_TRDTYPE.F_DESC AS TRADEDESC,
dbo.T_ITEM.F_DESC AS ITEMDESC, dbo.T_INVOTYPE.F_DESC AS INVOTYPEDESC,
dbo.T_PAYTERM.F_DESC AS PAYTERMDESC,
dbo.T_PAYTYPE.F_DESC AS PAYTYPEDESC,
dbo.T_CUST.F_NAMESHT AS F_NAMESHT, dbo.T_EMP.F_NAME AS F_NAME,
dbo.T_EMP.F_LOGIN AS F_LOGIN,
dbo.T_ITEMTYPE.F_ISBOARD AS ITEMTYPEISBOARD
FROM dbo.T_EMP INNER JOIN
dbo.T_ITEMTYPE INNER JOIN
dbo.T_ITEM ON dbo.T_ITEMTYPE.F_ID = dbo.T_ITEM.F_ITEMTYPE INNER JOIN
dbo.T_PAYTERM INNER JOIN
dbo.T_INVOTYPE INNER JOIN
dbo.T_PAYTYPE INNER JOIN
dbo.T_CUST INNER JOIN
dbo.T_TRDTYPE INNER JOIN
dbo.T_SALESORDHDR ON
dbo.T_TRDTYPE.F_ID = dbo.T_SALESORDHDR.F_TRDTYPE ON
dbo.T_CUST.F_ID = dbo.T_SALESORDHDR.F_CUSTID ON
dbo.T_PAYTYPE.F_ID = dbo.T_SALESORDHDR.F_PAYTYPE ON
dbo.T_INVOTYPE.F_ID = dbo.T_SALESORDHDR.F_INVOTYPE ON
dbo.T_PAYTERM.F_ID = dbo.T_SALESORDHDR.F_PAYTERM ON
dbo.T_ITEM.F_ID = dbo.T_SALESORDHDR.F_ITEMID ON
dbo.T_EMP.F_ID = dbo.T_CUST.F_EMPID