資料庫查詢語法錯誤!<br><br>SELECT top 2  BD_Serial, BD_Name ,BD_Out,BD_OutLink, BD_ArticleType, BD_Link FROM TO_PromotionSub LEFT JOIN TO_PromotionMain ON FK = PM_Serial LEFT JOIN TO_BoardData ON PM_Serial = BD_PM_Serial WHERE DK = 1 AND ( PS_Model1 = 'TLG04308PC' OR PS_Model2 = 'TLG04308PC' OR PS_Model3 = 'TLG04308PC' OR PS_Model4 = 'TLG04308PC' OR PS_Model5 = 'TLG04308PC' OR PS_Model6 = 'TLG04308PC' OR PS_Model7 = 'TLG04308PC' OR PS_Model8 = 'TLG04308PC' OR PS_Model9 = 'TLG04308PC' OR PS_Model10 = 'TLG04308PC' OR PS_Model11 = 'TLG04308PC' OR PS_Model12 = 'TLG04308PC' OR PS_Model13 = 'TLG04308PC' OR PS_Model14 = 'TLG04308PC' OR PS_Model15 = 'TLG04308PC' OR PS_Model16 = 'TLG04308PC' OR PS_Model17 = 'TLG04308PC' OR PS_Model18 = 'TLG04308PC' OR PS_Model19 = 'TLG04308PC' OR PS_Model20 = 'TLG04308PC' ) AND  PM_Available = 1 AND PM_Status = 1 AND PM_On = 1  AND CONVERT( DATETIME, CONVERT( CHAR(10), PM_StartDate, 20 ) + ' ' + PM_StartTime ) <= GETDATE() AND CONVERT( DATETIME, CONVERT( CHAR(10), PM_EndDate, 20 ) + ' ' + PM_EndTime ) >= GETDATE() AND BD_Type = 21 AND  BD_Available = 1 AND BD_Status = 1 AND BD_On = 1  AND CONVERT( DATETIME, CONVERT( CHAR(10), BD_StartDate, 20 ) + ' ' + BD_StartTime ) <= GETDATE() AND CONVERT( DATETIME, CONVERT( CHAR(10), BD_EndDate, 20 ) + ' ' + BD_EndTime ) >= GETDATE()  AND BD_ViewPower = 1 ORDER BY BD_SortNumber DESC<br><br>System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'BD_Out'.
Invalid column name 'BD_OutLink'.
   於 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   於 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   於 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   於 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   於 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   於 System.Data.SqlClient.SqlDataReader.get_MetaData()
   於 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   於 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   於 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   於 System.Data.SqlClient.SqlCommand.ExecuteReader()
   於 ccioo.Data.DB.ExecuteReader(String myQuery)
ClientConnectionId:53e1f884-be64-421b-b8e3-7b59cf7a4e48
Error Number:207,State:1,Class:16