英文:
Access too many fields defined - What is the limit?
问题
我已阅读StackOverflow上的其他信息,其中提到Union查询的字段限制是所有要联合的查询中总共不超过255个字段。我有点困惑,因为我有一个包括1078个总字段(14个查询中的77个字段)的查询,它可以成功联合。我尝试更新要显示的字段,已经增加到总计1274个字段(现在是91个字段,分布在14个查询中)。第一个包括1078个字段的Union查询可以正常工作,但更新后的包括1274个字段的Union查询则不行。
我的困惑来自其他帖子,我在那里读到255是联合查询中所有查询的字段的最大数量。根据这个规定,第一个查询本不应该成功联合,但它却一直在工作。我一直怀疑字段限制是否存在,直到今天我收到了这个错误。非常感谢提供见解,以下是两个Union查询,第二个是有问题的。我已截取它们,只包括了第一个Union ALL,因为将所有SQL都放在这里会使我的帖子达到70,000多个字符。
正常工作的Union查询:
SELECT Qry_ScheduledItems.Sales_Order_Number, Qry_ScheduledItems.Customer_Order_Number, Qry_ScheduledItems.Customer_Name, Qry_ScheduledItems.Ship_To_Location, Qry_ScheduledItems.Date_Created, Qry_ScheduledItems.Date_Due, Qry_ScheduledItems.Part_Number, Qry_ScheduledItems.Quantity_Ordered, Qry_JobTicket.Pcs_Ordered, Qry_ScheduledItems.Unit_of_Measure, Qry_ScheduledItems.RIP_Footage, Qry_ScheduledItems.Mould_Footage, "" AS Previous_Operation, "" AS Previous_Date_Ran, Qry_ScheduledItems.Operation1 AS Current_Operation, Qry_ScheduledItems.Date_Scheduled1 AS Date_Scheduled, Qry_ScheduledItems.Date_Ran1 AS Date_Ran, Qry_ScheduledItems.Operation2 AS Next_Operation, Qry_ScheduledItems.Date_Scheduled2 AS Next_Operation_Date, Qry_ScheduledItems.Date_Ran2 AS Next_Operation_Date_Ran, Qry_JobTicket.Raw_Material, Qry_JobTicket.RIP_Width, Qry_JobTicket.BD_FTG, Qry_JobTicket.Resaw_Passes, Qry_JobTicket.Yield_Cut, Qry_JobTicket.Lumber_Notes, Qry_JobTicket.Sheet_Size, Qry_JobTicket.Optimal_RIP_Size, Qry_JobTicket.Required_RIP_Size, Qry_JobTicket.Off_Fall, Qry_JobTicket.Cuts_Per_Sheet, Qry_JobTicket.Pieces, Qry_JobTicket.Sheets_Needed, Qry_ScheduledItems.RIP_Quantity, Qry_JobTicket.Profile_Size, Qry_JobTicket.Number_Of_Passes, Qry_JobTicket.Moulder_Notes, Qry_ScheduledItems.Mould_Quantity, Qry_JobTicket.Wrap_Color1, Qry_JobTicket.Wrap_Slit1, Qry_JobTicket.Wrap_SQFTG1, Qry_JobTicket.Wrap_Color2, Qry_JobTicket.Wrap_Slit2, Qry_JobTicket.Wrap_SQFTG2, Qry_JobTicket.Wrap_Color3, Qry_JobTicket.Wrap_Slit3, Qry_JobTicket.Wrap_SQFTG3, Qry_JobTicket.Foil_Color1, Qry_JobTicket.Foil_Slit1, Qry_JobTicket.Foil_SQFTG1, Qry_JobTicket.Foil_Color2, Qry_JobTicket.Foil_Slit2, Qry_JobTicket.Foil_SQFTG2, Qry_JobTicket.Foil_Color3, Qry_JobTicket.Foil_Slit3, Qry_JobTicket.Foil_SQFTG3, Qry_JobTicket.Foil_Color4, Qry_JobTicket.Foil_Slit4, Qry_JobTicket.Foil_SQFTG4, Qry_ScheduledItems.Wrap_Quantity, Qry_JobTicket.Finish_Number, Qry_JobTicket.Step1, Qry_JobTicket.Step2, Qry_JobTicket.Step3, Qry_JobTicket.Step4, Qry_JobTicket.Step5, Qry_JobTicket.Step6, Qry_JobTicket.Step7, Qry_JobTicket.Step8, Qry_JobTicket.Step9, Qry_JobTicket.Step10, Qry_JobTicket.Paint_Notes, Qry_ScheduledItems.Paint_Quantity, Qry_JobTicket.Assembly_Notes, Qry_JobTicket.Package_Notes, Qry_ScheduledItems.Pack_Quantity, Qry_ScheduledItems.Date_Shipped
FROM Qry_JobTicket INNER JOIN Qry_ScheduledItems ON Qry_JobTicket.Sales_Order_Number = Qry_ScheduledItems.Sales_Order_Number
WHERE (((Qry_ScheduledItems.Operation1) Is Not Null) AND ((Qry_ScheduledItems.Date_Scheduled1) Is Not Null) AND ((Qry_ScheduledItems.Date_Ran1) Is Null) AND ((Qry_ScheduledItems.Date_Shipped) Is Null))
UNION ALL SELECT Qry_ScheduledItems.Sales_Order_Number, Qry_ScheduledItems.Customer_Order_Number, Qry_ScheduledItems.Customer_Name, Qry_ScheduledItems.Ship_To_Location, Qry_ScheduledItems.Date_Created, Qry_ScheduledItems.Date_Due, Qry_ScheduledItems.Part_Number, Qry_ScheduledItems.Quantity_Ordered, Qry_JobTicket.Pcs_Ordered, Qry_ScheduledItems.Unit_of_Measure, Qry_ScheduledItems.RIP_Footage, Qry_ScheduledItems.Mould_Footage, Qry_ScheduledItems.Operation1 AS Previous_Operation, Qry_ScheduledItems.Date_Ran1 AS Previous_Date_Ran, Qry_ScheduledItems.Operation2 AS Operation, Qry_ScheduledItems.Date_Scheduled2 AS Date_Scheduled, Qry_ScheduledItems.Date_Ran2 AS Date_Ran, Qry_ScheduledItems.Operation3 AS Next_Operation, Qry_ScheduledItems.Date_Scheduled3 AS Next_Operation_Date, Qry_ScheduledItems.Date_Ran3 AS Next_Operation_Date_Ran, Qry_JobTicket.Raw_Material, Qry_JobTicket.RIP_Width, Qry_JobTicket.BD_FTG, Qry_JobTicket.Resaw_Passes, Qry_JobTicket.Yield_Cut, Qry_JobTicket.Lumber_Notes, Qry_JobTicket.Sheet_Size, Qry_JobTicket.Optimal_RIP_Size, Qry_JobTicket.Required_RIP_Size, Qry_JobTicket.Off_Fall, Qry_JobTicket.Pieces, Qry_Job
<details>
<summary>英文:</summary>
I have read elsewhere on StackOverflow that the limit for Union Queries is 255 fields across all queries you are trying to Union. I am a bit confused, as I have one with 1078 total fields (77 across 14 queries) and it joins together fine. I have attempted to update the fields being displayed, and have gone up to 1274 total fields (91 now, across 14 queries). The first 1078 Union works but not the updated 1274 Union.
My confusion comes from the other threads where I have read 255 is the max number of fields across ALL queries in the union. The first one should not join then, but it is and has been. I was skeptical of the field limit even existing until I got this error today. Insight would be much appreciated, below are the two Union queries with the **second** being the troublesome one. I have cut them off to just the first Union ALL as putting all of the SQL in there takes my post to 70,000 something characters.
**Working Union:**
SELECT Qry_ScheduledItems.Sales_Order_Number, Qry_ScheduledItems.Customer_Order_Number, Qry_ScheduledItems.Customer_Name, Qry_ScheduledItems.Ship_To_Location, Qry_ScheduledItems.Date_Created, Qry_ScheduledItems.Date_Due, Qry_ScheduledItems.Part_Number, Qry_ScheduledItems.Quantity_Ordered, Qry_JobTicket.Pcs_Ordered, Qry_ScheduledItems.Unit_of_Measure, Qry_ScheduledItems.RIP_Footage, Qry_ScheduledItems.Mould_Footage, "" AS Previous_Operation, "" AS Previous_Date_Ran, Qry_ScheduledItems.Operation1 AS Current_Operation, Qry_ScheduledItems.Date_Scheduled1 AS Date_Scheduled, Qry_ScheduledItems.Date_Ran1 AS Date_Ran, Qry_ScheduledItems.Operation2 AS Next_Operation, Qry_ScheduledItems.Date_Scheduled2 AS Next_Operation_Date, Qry_ScheduledItems.Date_Ran2 AS Next_Operation_Date_Ran, Qry_JobTicket.Raw_Material, Qry_JobTicket.RIP_Width, Qry_JobTicket.BD_FTG, Qry_JobTicket.Resaw_Passes, Qry_JobTicket.Yield_Cut, Qry_JobTicket.Lumber_Notes, Qry_JobTicket.Sheet_Size, Qry_JobTicket.Optimal_RIP_Size, Qry_JobTicket.Required_RIP_Size, Qry_JobTicket.Off_Fall, Qry_JobTicket.Cuts_Per_Sheet, Qry_JobTicket.Pieces, Qry_JobTicket.Sheets_Needed, Qry_ScheduledItems.RIP_Quantity, Qry_JobTicket.Profile_Size, Qry_JobTicket.Number_Of_Passes, Qry_JobTicket.Moulder_Notes, Qry_ScheduledItems.Mould_Quantity, Qry_JobTicket.Wrap_Color1, Qry_JobTicket.Wrap_Slit1, Qry_JobTicket.Wrap_SQFTG1, Qry_JobTicket.Wrap_Color2, Qry_JobTicket.Wrap_Slit2, Qry_JobTicket.Wrap_SQFTG2, Qry_JobTicket.Wrap_Color3, Qry_JobTicket.Wrap_Slit3, Qry_JobTicket.Wrap_SQFTG3, Qry_JobTicket.Foil_Color1, Qry_JobTicket.Foil_Slit1, Qry_JobTicket.Foil_SQFTG1, Qry_JobTicket.Foil_Color2, Qry_JobTicket.Foil_Slit2, Qry_JobTicket.Foil_SQFTG2, Qry_JobTicket.Foil_Color3, Qry_JobTicket.Foil_Slit3, Qry_JobTicket.Foil_SQFTG3, Qry_JobTicket.Foil_Color4, Qry_JobTicket.Foil_Slit4, Qry_JobTicket.Foil_SQFTG4, Qry_ScheduledItems.Wrap_Quantity, Qry_JobTicket.Finish_Number, Qry_JobTicket.Step1, Qry_JobTicket.Step2, Qry_JobTicket.Step3, Qry_JobTicket.Step4, Qry_JobTicket.Step5, Qry_JobTicket.Step6, Qry_JobTicket.Step7, Qry_JobTicket.Step8, Qry_JobTicket.Step9, Qry_JobTicket.Step10, Qry_JobTicket.Paint_Notes, Qry_ScheduledItems.Paint_Quantity, Qry_JobTicket.Assembly_Notes, Qry_JobTicket.Package_Notes, Qry_ScheduledItems.Pack_Quantity, Qry_ScheduledItems.Date_Shipped
FROM Qry_JobTicket INNER JOIN Qry_ScheduledItems ON Qry_JobTicket.Sales_Order_Number = Qry_ScheduledItems.Sales_Order_Number
WHERE (((Qry_ScheduledItems.Operation1) Is Not Null) AND ((Qry_ScheduledItems.Date_Scheduled1) Is Not Null) AND ((Qry_ScheduledItems.Date_Ran1) Is Null) AND ((Qry_ScheduledItems.Date_Shipped) Is Null))
UNION ALL SELECT Qry_ScheduledItems.Sales_Order_Number, Qry_ScheduledItems.Customer_Order_Number, Qry_ScheduledItems.Customer_Name, Qry_ScheduledItems.Ship_To_Location, Qry_ScheduledItems.Date_Created, Qry_ScheduledItems.Date_Due, Qry_ScheduledItems.Part_Number, Qry_ScheduledItems.Quantity_Ordered, Qry_JobTicket.Pcs_Ordered, Qry_ScheduledItems.Unit_of_Measure, Qry_ScheduledItems.RIP_Footage, Qry_ScheduledItems.Mould_Footage, Qry_ScheduledItems.Operation1 AS Previous_Operation, Qry_ScheduledItems.Date_Ran1 AS Previous_Date_Ran, Qry_ScheduledItems.Operation2 AS Current_Operation, Qry_ScheduledItems.Date_Scheduled2 AS Date_Scheduled, Qry_ScheduledItems.Date_Ran2 AS Date_Ran, Qry_ScheduledItems.Operation3 AS Next_Operation, Qry_ScheduledItems.Date_Scheduled3 AS Next_Operation_Date, Qry_ScheduledItems.Date_Ran3 AS Next_Operation_Date_Ran, Qry_JobTicket.Raw_Material, Qry_JobTicket.RIP_Width, Qry_JobTicket.BD_FTG, Qry_JobTicket.Resaw_Passes, Qry_JobTicket.Yield_Cut, Qry_JobTicket.Lumber_Notes, Qry_JobTicket.Sheet_Size, Qry_JobTicket.Optimal_RIP_Size, Qry_JobTicket.Required_RIP_Size, Qry_JobTicket.Off_Fall, Qry_JobTicket.Pieces, Qry_JobTicket.Cuts_Per_Sheet, Qry_JobTicket.Sheets_Needed, Qry_ScheduledItems.RIP_Quantity, Qry_JobTicket.Profile_Size, Qry_JobTicket.Number_Of_Passes, Qry_JobTicket.Moulder_Notes, Qry_ScheduledItems.Mould_Quantity, Qry_JobTicket.Wrap_Color1, Qry_JobTicket.Wrap_Slit1, Qry_JobTicket.Wrap_SQFTG1, Qry_JobTicket.Wrap_Color2, Qry_JobTicket.Wrap_Slit2, Qry_JobTicket.Wrap_SQFTG2, Qry_JobTicket.Wrap_Color3, Qry_JobTicket.Wrap_Slit3, Qry_JobTicket.Wrap_SQFTG3, Qry_JobTicket.Foil_Color1, Qry_JobTicket.Foil_Slit1, Qry_JobTicket.Foil_SQFTG1, Qry_JobTicket.Foil_Color2, Qry_JobTicket.Foil_Slit2, Qry_JobTicket.Foil_SQFTG2, Qry_JobTicket.Foil_Color3, Qry_JobTicket.Foil_Slit3, Qry_JobTicket.Foil_SQFTG3, Qry_JobTicket.Foil_Color4, Qry_JobTicket.Foil_Slit4, Qry_JobTicket.Foil_SQFTG4, Qry_ScheduledItems.Wrap_Quantity, Qry_JobTicket.Finish_Number, Qry_JobTicket.Step1, Qry_JobTicket.Step2, Qry_JobTicket.Step3, Qry_JobTicket.Step4, Qry_JobTicket.Step5, Qry_JobTicket.Step6, Qry_JobTicket.Step7, Qry_JobTicket.Step8, Qry_JobTicket.Step9, Qry_JobTicket.Step10, Qry_JobTicket.Paint_Notes, Qry_ScheduledItems.Paint_Quantity, Qry_JobTicket.Assembly_Notes, Qry_JobTicket.Package_Notes, Qry_ScheduledItems.Pack_Quantity, Qry_ScheduledItems.Date_Shipped
FROM Qry_JobTicket INNER JOIN Qry_ScheduledItems ON Qry_JobTicket.Sales_Order_Number = Qry_ScheduledItems.Sales_Order_Number
WHERE (((Qry_ScheduledItems.Operation2) Is Not Null) AND ((Qry_ScheduledItems.Date_Scheduled2) Is Not Null) AND ((Qry_ScheduledItems.Date_Ran2) Is Null) AND ((Qry_ScheduledItems.Date_Shipped) Is Null))
**Broken Union:**
SELECT Qry_ScheduledItems.Sales_Order_Number, Qry_ScheduledItems.Customer_Order_Number, Qry_ScheduledItems.Customer_Name, Qry_ScheduledItems.Ship_To_Location, Qry_ScheduledItems.Date_Created, Qry_ScheduledItems.Date_Due, Qry_ScheduledItems.Part_Number, Qry_ScheduledItems.Quantity_Ordered, Qry_JobTicket.Pcs_Ordered, Qry_ScheduledItems.Unit_of_Measure, Qry_ScheduledItems.RIP_Footage, Qry_ScheduledItems.Mould_Footage, Null AS Previous_Operation, Null AS Previous_Date_Ran, Qry_ScheduledItems.Operation1 AS Operation, Qry_ScheduledItems.Date_Scheduled1 AS Date_Scheduled, Qry_ScheduledItems.Date_Ran1 AS Date_Ran, Qry_ScheduledItems.Operation2 AS Next_Operation, Qry_ScheduledItems.Date_Scheduled2 AS Next_Operation_Date, Qry_ScheduledItems.Date_Ran2 AS Next_Operation_Date_Ran, Qry_JobTicket.Raw_Material, Qry_JobTicket.RIP_Width, Qry_JobTicket.BD_FTG, Qry_JobTicket.Resaw_Passes, Qry_JobTicket.Yield_Cut, Qry_JobTicket.Lumber_Notes, Qry_JobTicket.Sheet_Size, Qry_JobTicket.Optimal_RIP_Size, Qry_JobTicket.Required_RIP_Size, Qry_JobTicket.Off_Fall, Qry_JobTicket.Cuts_Per_Sheet, Qry_JobTicket.Pieces, Qry_JobTicket.Sheets_Needed, Qry_ScheduledItems.RIP_Quantity, Qry_JobTicket.Profile_Size, Qry_JobTicket.Moulder_Number, Qry_JobTicket.Number_Of_Passes, Qry_JobTicket.Moulder_Notes, Qry_ScheduledItems.Mould_Quantity, Qry_JobTicket.Wrap_Number1, Qry_JobTicket.Wrap_Color1, Qry_JobTicket.Wrap_Slit1, Qry_JobTicket.Wrap_SQFTG1, Qry_JobTicket.Wrap_Number2, Qry_JobTicket.Wrap_Color2, Qry_JobTicket.Wrap_Slit2, Qry_JobTicket.Wrap_SQFTG2, Qry_JobTicket.Wrap_Number3, Qry_JobTicket.Wrap_Color3, Qry_JobTicket.Wrap_Slit3, Qry_JobTicket.Wrap_SQFTG3, Qry_ScheduledItems.Wrap_Quantity, Qry_JobTicket.Foil_Number1, Qry_JobTicket.Foil_Color1, Qry_JobTicket.Foil_Slit1, Qry_JobTicket.Foil_SQFTG1, Qry_JobTicket.Foil1_Number_Slits, Qry_JobTicket.Foil_Number2, Qry_JobTicket.Foil_Color2, Qry_JobTicket.Foil_Slit2, Qry_JobTicket.Foil_SQFTG2, Qry_JobTicket.Foil2_Number_Slits, Qry_JobTicket.Foil_Number3, Qry_JobTicket.Foil_Color3, Qry_JobTicket.Foil_Slit3, Qry_JobTicket.Foil_SQFTG3, Qry_JobTicket.Foil3_Number_Slits, Qry_JobTicket.Foil_Number4, Qry_JobTicket.Foil_Color4, Qry_JobTicket.Foil_Slit4, Qry_JobTicket.Foil_SQFTG4, Qry_JobTicket.Foil4_Number_Slits, Qry_JobTicket.[Wrap/Foil_Notes], Qry_JobTicket.Finish_Number, Qry_JobTicket.Step1, Qry_JobTicket.Step2, Qry_JobTicket.Step3, Qry_JobTicket.Step4, Qry_JobTicket.Step5, Qry_JobTicket.Step6, Qry_JobTicket.Step7, Qry_JobTicket.Step8, Qry_JobTicket.Step9, Qry_JobTicket.Step10, Qry_JobTicket.Paint_Notes, Qry_ScheduledItems.Paint_Quantity, Qry_JobTicket.Assembly_Notes, Qry_JobTicket.Package_Notes, Qry_JobTicket.Order_Notes, Qry_ScheduledItems.Pack_Quantity, Qry_ScheduledItems.Date_Shipped
FROM Qry_JobTicket INNER JOIN Qry_ScheduledItems ON Qry_JobTicket.Sales_Order_Number = Qry_ScheduledItems.Sales_Order_Number
WHERE (((Qry_ScheduledItems.Operation1) Is Not Null) AND ((Qry_ScheduledItems.Date_Scheduled1) Is Not Null) AND ((Qry_ScheduledItems.Date_Ran1) Is Null) AND ((Qry_ScheduledItems.Date_Shipped) Is Null));
UNION ALL SELECT Qry_ScheduledItems.Sales_Order_Number, Qry_ScheduledItems.Customer_Order_Number, Qry_ScheduledItems.Customer_Name, Qry_ScheduledItems.Ship_To_Location, Qry_ScheduledItems.Date_Created, Qry_ScheduledItems.Date_Due, Qry_ScheduledItems.Part_Number, Qry_ScheduledItems.Quantity_Ordered, Qry_JobTicket.Pcs_Ordered, Qry_ScheduledItems.Unit_of_Measure, Qry_ScheduledItems.RIP_Footage, Qry_ScheduledItems.Mould_Footage, Qry_ScheduledItems.Operation1 AS Previous_Operation, Qry_ScheduledItems.Date_Ran1 AS Previous_Date_Ran, Qry_ScheduledItems.Operation2 AS Operation, Qry_ScheduledItems.Date_Scheduled2 AS Date_Scheduled, Qry_ScheduledItems.Date_Ran2 AS Date_Ran, Qry_ScheduledItems.Operation3 AS Next_Operation, Qry_ScheduledItems.Date_Scheduled3 AS Next_Operation_Date, Qry_ScheduledItems.Date_Ran3 AS Next_Operation_Date_Ran, Qry_JobTicket.Raw_Material, Qry_JobTicket.RIP_Width, Qry_JobTicket.BD_FTG, Qry_JobTicket.Resaw_Passes, Qry_JobTicket.Yield_Cut, Qry_JobTicket.Lumber_Notes, Qry_JobTicket.Sheet_Size, Qry_JobTicket.Optimal_RIP_Size, Qry_JobTicket.Required_RIP_Size, Qry_JobTicket.Off_Fall, Qry_JobTicket.Pieces, Qry_JobTicket.Cuts_Per_Sheet, Qry_JobTicket.Sheets_Needed, Qry_ScheduledItems.RIP_Quantity, Qry_JobTicket.Profile_Size, Qry_JobTicket.Moulder_Number, Qry_JobTicket.Number_Of_Passes, Qry_JobTicket.Moulder_Notes, Qry_ScheduledItems.Mould_Quantity, Qry_JobTicket.Wrap_Number1, Qry_JobTicket.Wrap_Color1, Qry_JobTicket.Wrap_Slit1, Qry_JobTicket.Wrap_SQFTG1, Qry_JobTicket.Wrap_Number2, Qry_JobTicket.Wrap_Color2, Qry_JobTicket.Wrap_Slit2, Qry_JobTicket.Wrap_SQFTG2, Qry_JobTicket.Wrap_Number3, Qry_JobTicket.Wrap_Color3, Qry_JobTicket.Wrap_Slit3, Qry_JobTicket.Wrap_SQFTG3, Qry_ScheduledItems.Wrap_Quantity, Qry_JobTicket.Foil_Number1, Qry_JobTicket.Foil_Color1, Qry_JobTicket.Foil_Slit1, Qry_JobTicket.Foil_SQFTG1, Qry_JobTicket.Foil1_Number_Slits, Qry_JobTicket.Foil_Number2, Qry_JobTicket.Foil_Color2, Qry_JobTicket.Foil_Slit2, Qry_JobTicket.Foil_SQFTG2, Qry_JobTicket.Foil2_Number_Slits, Qry_JobTicket.Foil_Number3, Qry_JobTicket.Foil_Color3, Qry_JobTicket.Foil_Slit3, Qry_JobTicket.Foil_SQFTG3, Qry_JobTicket.Foil3_Number_Slits, Qry_JobTicket.Foil_Number4, Qry_JobTicket.Foil_Color4, Qry_JobTicket.Foil_Slit4, Qry_JobTicket.Foil_SQFTG4, Qry_JobTicket.Foil4_Number_Slits, Qry_JobTicket.[Wrap/Foil_Notes], Qry_JobTicket.Finish_Number, Qry_JobTicket.Step1, Qry_JobTicket.Step2, Qry_JobTicket.Step3, Qry_JobTicket.Step4, Qry_JobTicket.Step5, Qry_JobTicket.Step6, Qry_JobTicket.Step7, Qry_JobTicket.Step8, Qry_JobTicket.Step9, Qry_JobTicket.Step10, Qry_JobTicket.Paint_Notes, Qry_ScheduledItems.Paint_Quantity, Qry_JobTicket.Assembly_Notes, Qry_JobTicket.Package_Notes, Qry_JobTicket.Order_Notes, Qry_ScheduledItems.Pack_Quantity, Qry_ScheduledItems.Date_Shipped
FROM Qry_JobTicket INNER JOIN Qry_ScheduledItems ON Qry_JobTicket.Sales_Order_Number = Qry_ScheduledItems.Sales_Order_Number
WHERE (((Qry_ScheduledItems.Operation2) Is Not Null) AND ((Qry_ScheduledItems.Date_Scheduled2) Is Not Null) AND ((Qry_ScheduledItems.Date_Ran2) Is Null) AND ((Qry_ScheduledItems.Date_Shipped) Is Null));
** Sorry about the Code Boxes, I cannot figure out how to get them to wrap text **
</details>
# 答案1
**得分**: 1
限制是255个*输出*字段。这些字段的来源并不重要。
但是,查询本身有字符总限制。您可以通过使用*别名*来大大节省字符,例如:
从 Qry_JobTicket 作为 J 内连接 Qry_ScheduledItems 作为 S On J.Sales_Order_number = ...
<details>
<summary>英文:</summary>
The limit is 255 *output* fields. From where these origin doesn't matter.
However, the query itself has a total limit of characters. You can save dramatically on that by using *alias*, like:
FROM Qry_JobTicket As J INNER JOIN Qry_ScheduledItems As S On J.Sales_Order_number = ...
</details>
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论