union附近的语法不正确 [英] Incorrect syntax near union

问题描述

你好，我有这个存储的生产者联合许多表，我想通过apartemetnnoen订购，因为你看到了但仍然在工会附近给我错误



我尝试过：

hello, i have this stored producer that union many tables and i want to order by apartemetnnoen as u see down and still give me error near union

What I have tried:

SELECT 
	   [Spare6]
      ,[Spare5]
      ,[Spare4]
      ,[Spare3]
      ,[Spare2]
      ,[Spare1]
      ,[details]
      ,[note]
      ,[documents]
      ,[termsofpaymneten]
      ,[termsofpaymnet]
      ,[aprtmentstatusen]
      ,[aprtmentstatus]
      ,[amountdateen]
      ,[amountdate]
      ,[amountleft]
      ,[amountpaid]
      ,[rent]
      ,[noofpayemtsen]
      ,[noofpayemts]
      ,[sourceen]
      ,[source]
      ,[iddateen]
      ,[iddate]
      ,[idnumber]
      ,convert(datetime, contractenen, 111) as contractenen
      ,[contracten]
      ,[contractstarten]
      ,[contractstart]
      ,[contractnoen]
      ,[contractno]
      ,[nationalityen]
      ,[nationality]
      ,[secondpartyen]
      ,[secondparty]
      ,[firstpartyen]
      ,[firstparty]
      ,[apartemetnnoen]
      ,[apartemetnno]
      ,[Bulidingnoen]
      ,[Bulidingno]
      ,[No] FROM [All_Vech].[dbo].[Bulding_Sharfya]  
	WHERE [idnumber] LIKE '%' + @idnumber + '%' OR [Bulidingno] Like '%' + @Bulidingno + '%' OR [Bulidingnoen] LIKE '%' + @Bulidingnoen + '%' OR [apartemetnno] LIKE '%' + @apartemetnno + '%'  OR [apartemetnnoen] LIKE '%' + @apartemetnnoen + '%'  OR secondparty LIKE '%' + @secondparty + '%' OR secondpartyen LIKE '%' + @secondpartyen + '%' OR nationality LIKE '%' + @nationality + '%' OR nationalityen LIKE '%' + @nationalityen + '%' OR [contractno] LIKE '%' + @contractno + '%'  OR [contractnoen] LIKE '%' +  @contractnoen + '%' OR [contracten] Like '%' + @contracten + '%' 
	ORDER BY apartemetnnoen DESC;
UNION

推荐答案

由于您只有一个SELECT语句，请从SQL末尾删除UNION子句。 />


换句话说

Since you have only one SELECT statement, remove the UNION clause from the end of you SQL.

In other words

...
	WHERE [idnumber] LIKE '%' + @idnumber + '%' OR [Bulidingno] Like '%' + @Bulidingno + '%' OR [Bulidingnoen] LIKE '%' + @Bulidingnoen + '%' OR [apartemetnno] LIKE '%' + @apartemetnno + '%'  OR [apartemetnnoen] LIKE '%' + @apartemetnnoen + '%'  OR secondparty LIKE '%' + @secondparty + '%' OR secondpartyen LIKE '%' + @secondpartyen + '%' OR nationality LIKE '%' + @nationality + '%' OR nationalityen LIKE '%' + @nationalityen + '%' OR [contractno] LIKE '%' + @contractno + '%'  OR [contractnoen] LIKE '%' +  @contractnoen + '%' OR [contracten] Like '%' + @contracten + '%' 
	ORDER BY apartemetnnoen DESC;
UNION

有关更多信息和示例，请查看 UNION（Transact-SQL）| Microsoft Docs [ ^ ]

这篇关于union附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！